Last Name Sort In Mac Numbers

The latest versions of Numbers make it much easier to sort by last name, even if the data includes only full names. The new functions TEXTBEFORE, TEXTAFTER and COUNTMATCHES allow you to put last name before the first name. You can also use REGEX to do it with an even shorter formula.

Comments: 6 Responses to “Last Name Sort In Mac Numbers”

    David Chadderton
    4 weeks ago

    I’m sure I saw in the video when you showed the function help that you can use -1 in TEXTBEFORE and TEXTAFTER to select the last match, which would simplify your formula a bit as COUNTMATCHES would be unnecessary.

    4 weeks ago

    David: You’re right!

    Gene
    4 weeks ago

    Another fine video! How did you discover the “fake space” feature? That is option+space for Van Buren?

    4 weeks ago

    Gene: It has been around for years. I used it in the 1990s for desktop publishing when you want to keep two words together on the same line and for similar things.

    Dan Bails
    4 weeks ago

    This is great Gary, You know almost everything, right? I have another wrench for my own list. I have a mixture of people’s names and company names. I have tried putting the “fake space” in the company name but I get an error. Barn¬†Yoga¬†Group – “Argument 3 of TEXTAFTER is invalid.” I guess your formula doesn’t work if there are no spaces.

    4 weeks ago

    Dan: Right, it needs a space to work. You can use IFERROR to just use the text as-is if you like.

Leave a New Comment Related to "Last Name Sort In Mac Numbers"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)