Parsing text in numbers
How can I convert text demarcated by spaces to separate columns in Numbers?
MacBook Air, macOS 13.6
How can I convert text demarcated by spaces to separate columns in Numbers?
MacBook Air, macOS 13.6
One way is to do something like this:
In B2, filled right:
=TEXTBETWEEN(" "&$A2&" "," "," ",COLUMN()−1)
More on TEXTBETWEEN here:
SG
Parsing text in numbers