Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

How parse Numbers cell into two cells

Using Numbers on Mac, I imported CSV file from Quicken. One column contains both number of shares and price/share data. How can I parse those cells/columns into separate cells/columns?

iMac 24″, macOS 13.2

Posted on Mar 8, 2023 6:12 AM

Reply
Question marked as Top-ranking reply

Posted on Mar 8, 2023 8:25 AM

You can add two adjacent columns, then use TEXTBEFORE and TEXTAFTER something like this:




In C1, filled down:


=TEXTBEFORE(B2," ")*1


In D1, filled down:


=TEXTAFTER(B2," ")*1


Use ; in the formulas instead of , if your region uses , as the decimal separator.


This assumes there is a space separating the numbers of share and price. If it's something else then put that between the " " in the formulas instead.


The *1 coerces the text to a number.


You can then "remove" the formulas in the added columns by selecting them, command-c to copy, Edit > Paste Formula Results. Then delete the original column if you want.


SG








SG

4 replies
Question marked as Top-ranking reply

Mar 8, 2023 8:25 AM in response to denJ138

You can add two adjacent columns, then use TEXTBEFORE and TEXTAFTER something like this:




In C1, filled down:


=TEXTBEFORE(B2," ")*1


In D1, filled down:


=TEXTAFTER(B2," ")*1


Use ; in the formulas instead of , if your region uses , as the decimal separator.


This assumes there is a space separating the numbers of share and price. If it's something else then put that between the " " in the formulas instead.


The *1 coerces the text to a number.


You can then "remove" the formulas in the added columns by selecting them, command-c to copy, Edit > Paste Formula Results. Then delete the original column if you want.


SG








SG

How parse Numbers cell into two cells

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.