separate combined data into 2 separate columns.

Have this data that is in a single column. Would like to separate it into 2 different columns. Is there an easy way to do this?

thanks. DG

[Edited by Moderator]

MacBook Pro 16″, macOS 26.0

Posted on Oct 4, 2025 10:46 AM

Top-ranking reply

Badunit

Level 7

30,336 points

Posted on Oct 4, 2025 12:34 PM

There are a few ways. Here is one.

C2 =VALUE(TEXTBEFORE(B2," "))

D2 =VALUE(TEXTBETWEEN(B2," "," ",2))

fill down with both formulas.

Format column C for two decimal places

The VALUE function turns them into actual numbers. Otherwise they would be text "numbers".

View in context

Similar questions

Is there a formula/function to split data out of one cell? Hello all ~ I copied a long list of first name, last name and email addresses out of an email. I want to be able to separate the data into 3 columns - first name, last name, email address. In Numbers, I managed to get the data into one column (A1) but it is one long column that looks like this: Column A first name1 last name1 first name2 last name2 etc. Is there any way to separate the individual data I need without having to go through manually and separating everything? It's a pretty long list. There there isn't anything separating the first name from the last name and the email address is only separated by the arrows <> as shown above. So it looks like this: Peyton M <***.com> I hope I explained this clearly. I am not a function/formula guru so if you need more information let me know. Thanks for your help. Judy [Edited by Moderator]
587 14

1 reply