💻 Software
Copying partial cell to another cell in OpenOffice Calc
Fresh5 days ago
Mar 15, 202620347 viewsConfidence Score0%
0%
Problem
Cell A1 says 0001 John Smith Cell A2 says 0002 Bill Snyder I want to basically split this, so one column just shows the numbers (0001, 0002, etc.) and then another column just shows the name. The first part is easy. Using the function "=LEFT(A1;4)" I can get 0001. How can I grab the name? Using "RI…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Copying partial cell to another cell in OpenOffice Calc
Low Risk
To get sub-string excluding first 4 characters (plus space) you can use function: It will result in 'John Smith Cell A2 says 0002 Bill Snyder'. You can also imitate text splitting with function, for example this formula will output '0001': Further, …
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix