It really gets sticky when you have more than two fields to deal with and if the separators are not all the same.

In this simple example, I use the substring extractors LEFT and RIGHT to parse out the first and last names based on where the separator, is found.

I plan on looking it over to see how it works too, teach me something more about applescript hopefully.

Jason, when you figure out how Nigel Garveys handler does its magic, I hope you will share the explanation.

I can explain how I did the rest of the script, but that handler is truly inspired.

Hiroto posted a similar script here in the Numbers discussions, which is very good too.

Then click the upper-left cell of the range where you want the split data, and command-v to paste.

You want to pick a paste area where there arent any values that you want to preserve.

If, after selecting cells in only one column and then running the script, youre still getting that message, could you post a screenshot with sample data That will help me see if there is a bug that needs squashing.

BTW, Excel is really good at splitting all kinds of text into columns.

However, in my experience, this Automator Service also does a very good job in most situations.

It isnt working for me I keep getting the message Did you select ONE column of cells with contents to split, despite having selected only cells in ONE column.

No problems here.

That error message appears when the script encounters any trouble, even if the error isnt related to selecting more than one column.

I suggest trying it on a few test cells, and if that works, inspect the cells you need to split to see if there is something unusual there.

Also in System Preferences Privacy Security Privacy Accessibility make sure both Automator.app and Script Editor.app are checked.

And, of course, dont forget to try quitting and restarting your machine.

Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums.

Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site.

All postings and use of the content on this site are subject to the.

How To Split An Excel Cell For Mac