How to Split Text to Columns in Numbers 14.0

For what I think you are trying to do I think you will be better off with formulas than with the Service, which assumes you split at a given delimiter.

You can try something like this:

In B2 of the example, filled down:

=TEXTBEFORE(A2,REGEX(" \d"))

In C2, filled down:

=REGEX.EXTRACT(A2,"\d+")

In D2, filled down:

TEXTAFTER(A2,REGEX("\d+"))

Use ; instead of , in the formulas if your regions uses , as the decimal separator.

After you've entered and filled the formulas and gotten the results you want, you can then "remove" the formulas by selecting the cells containing them, typing command-c, followed by Edit > Paste Formula Results.

Then you can analyze and sort as needed.

TEXTBEFORE - Apple Support

REGEX - Apple Support

REGEX.EXTRACT - Apple Support

SG

Have you tried the formula approach I suggested above?

I don't think the script you've linked to will do the job here, assuming you're trying to split out name, year, and occupation.

The script will split the string at a given delimiter, i.e. at every space or at every comma, etc. That's not what you want here, right?

If it is what you want (i.e., you want something different than the example you posted) then using it is easy. Just select the cells, run the script, click once in a destination cell, and command-v or Edit > Paste and Match Style to paste.

SG

With many/most scripts and shortcuts posted here, you select a cell or range of cells then run the script or shortcut.

Can you provide a link to the post/thread that has the shortcut you are using?