Remove numbers from the left until letters. Could it be done?

AppSheet AppSheet Q&A
1

I have a peculiar problem.

We get customer names from our economy system, and for some reason some customers have numbers in front of their names. The series goes from 1 to 99999. As you can see, sorting is not possible with this.

Example names:
123 Johnson & Johnson
4321 Dick Tracy 77-99
55991 Good productions 7 ltd.
Speven Stielberg

What I want:
Johnson & Johnson
Dick Tracy 77-99
Good productions 7 ltd.
Speven Stielberg

I’m not looking for a solution yet, I’d just like to know your thoughts on if this is possible, so I dont waste my time :thinking:

2

This woudl fix the [Name] issue. Though it might be work looking at preventing the numbers if you can.

IF(
   AND(
      ISNOTBLANK(NUMBER(INDEX(SPLIT([Name]," "),1))),
      NUMBER(INDEX(SPLIT([Name]," "),1))>0
   ),
   SUBSTITUTE([Name],INDEX(SPLIT([Name]," "),1),""),
   [Name]
)

Try this. But will only work for numbers that are the first work in the sentance and sperated by a space from the second word.

Simon@1minManager.com

3 Likes
3

This works like magic!

I now believe in magic.

Thank you so much! :smiley:

I added Trim() around the formula to remove empty space.

2 Likes