Does Text to Columns Service still exist for Numbers?

I'm looking for a way to split a single column of text into multiple columns in Numbers version version 4.3.1 (5249) with macOS High Sierra version 10.13.3.


I have found several references to a Numbers Service called Text to Columns with a link to Dropbox, but I get a file not found error from Dropbox when I click on the link.


The text I am trying to split is a name, which I could do using formulas if there was just a first name and last name, but in some cases there is a middle name or a nickname or more.


Any suggestions?


Thank you!

iMac, macOS High Sierra (10.13.3)

Posted on Feb 23, 2018 10:23 AM

Reply
Question marked as Top-ranking reply

Posted on Feb 23, 2018 11:04 AM

Here's an updated link to the Text to Columns Automator Service.


Double-click the downloaded .workflow package and give permission if necessary at System Preferences > Security & Privacy. Also make sure Automator.app is in the list and checked at System Preferences > Security & Privacy > Privacy > Accessibility.


To use, first select the cells in the column then click the run button and answer the prompt. Click a destination cell once and command-v or Edit > Paste and Match Style to paste.


SG

9 replies
Question marked as Top-ranking reply

Feb 23, 2018 11:04 AM in response to DebbieK93

Here's an updated link to the Text to Columns Automator Service.


Double-click the downloaded .workflow package and give permission if necessary at System Preferences > Security & Privacy. Also make sure Automator.app is in the list and checked at System Preferences > Security & Privacy > Privacy > Accessibility.


To use, first select the cells in the column then click the run button and answer the prompt. Click a destination cell once and command-v or Edit > Paste and Match Style to paste.


SG

Feb 23, 2018 7:40 PM in response to SGIII

In your instructions on using the automator app these instructions appear:To use, "first select the cells in the column then click the run button and answer the prompt. Click a destination cell once and command-v or Edit > Paste and Match Style to paste."

Just what or where is this run button one is supposed to click?

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Does Text to Columns Service still exist for Numbers?

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