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

[Ratatosk]

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 🤔

[1minManager · Accepted solution]

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   

[Ratatosk]

This works like magic!

I now believe in magic.

Thank you so much! 😃

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