How to split text into different cells?
Ive searched a little online, but only found it for Excel. Example.
How would I do this in Numbers?
Mac Pro, OS X Yosemite (10.10.3)
Ive searched a little online, but only found it for Excel. Example.
How would I do this in Numbers?
Mac Pro, OS X Yosemite (10.10.3)
I assume you are posting in this thread because you need to separate imported text into columns. If so, follow the instructions in the post above (the one marked Solved). In addition to the steps described there, you may need to check Automator.app at System Preferences > Security & Privacy > Privacy > Accessibility. The whole process should take less than a minute.
SG
Thanks SGIII for writing the workflow and sharing it. This is a lifesaver. 🙂
The file doesn't seem to exist any more, any idea where I can get it?
Thats great thank you! Forgive my ignorance but what do I do with it?
The dropbox link for Text to Columns Automator Workflow seems to be no longer available / broken.
Hi, this is helpful but I am coming to this 2 years after it was posted and the dropbox link no longer works. Is there somewhere I can get the file from or is there now a different solution?
Here's an updated dropbox link for the Text to Columns Automator Service.
Make sure 'Automator.app' is checked at System Preferences > Security & Privacy > Privacy > Accessibility.
SG
Thank you @SGIII. Works like a charm.
How to split text into different cells?