Functions For Working With Text In Mac Numbers

Learn how to test and manipulate text in cells in Mac Numbers. You can search for characters, replace them, grab parts of text and more.

Comments: 5 Responses to “Functions For Working With Text In Mac Numbers”

    Paul Feliciano
    2 years ago

    It's a real help to have a bit of a dive into string functions. Very good video's, clear, concise, and you stay on point. I appreciate the practical examples. It's a bit of a challenge to remember the list of string functions, what and how they do what they do. It's great to have examples to refer to. I only spend maybe an hour or two in a week with a spreadsheets trying to get done what I need to get done. When I'm trying to tease information, I remember Gary and MacMost if nothing else.

    Andrew W
    2 years ago

    Thank you - this a great introduction to subject and has helped me get my head round the tricky syntax needed to manipulate text in numbers.

    Esther W
    2 years ago

    Gary's advice is always super helpful when I'm trying to make spreadsheets do what I want them to. It's great to find out the simplest way to get the results I need. Many thanks Gary and Patreon.

    Fatih
    1 year ago

    Hi Gary, thank you for all your videos. What I am trying to do is, I want to change every second letter of the words in the cell, lets say "Hey Gary how are you" - "H2y G2ry h2w a2e y2u" is that possible?

    1 year ago

    Fatih: Interesting. What's the application? Can't imagine what that would be used for. I would think you'd need to use a regex expression for that, but it would be a complex one. I don't know the solution.

Comments Closed.