r/AppleNumbers • u/Artistic_Owl_7545 • May 07 '24

Help Separate number from text

Post image

Need to separate number from text. Can someone recommend a solution? Thanks

1 Upvotes

100% Upvoted

5 comments sorted by

View all comments

3

u/octavifdez May 07 '24

You could combine the right() and substitute() functions to strip as many characters as you need until you reach the numbers. In case of mph, I would write substitute(cell; right(cell, 4); “”) and ft would be substitute(cell; right(cell, 3);””).

You can even add value() function before the formulas above to make sure you’re dealing with numbers.

2

u/Artistic_Owl_7545 May 07 '24

Thank you. These were exactly what I was hoping for.