Q: Split text in numbers
Hello, how can i split text in different cells?
PS: text to columns workflow not working...
Posted on Feb 19, 2016 12:15 PM
So if I understand you correctly, after pasting in from Pages you have something like this?
And you want to split the name into First and Last name, with First in one column and Last in another?
If so, you can do this:
Select the cells with the data you want to split, here A2:A3:
With the cells still selected, choose 'Text to Columns' from the Numbers > Services menu and choose Space as your delimiter (I'm assuming there's a space between the first and last name).
Click once in cell C2 and command-v or Edit > Paste and Match Style, giving you this:
Add header labels for columns C and D and delete column A, resulting in:
SG
P.S. This assumes you are using this Automator Service (Dropbox download).
Posted on Feb 19, 2016 1:19 PM












