find position of first alpha character

A

Austin Joyner

I would like to remove numeric characters from the front of the contents of
a cell. I could use the Right Function if i could determine the correct
position of the first alpha character. Problem is various lengths of
numbers and some without numbers.

123 XYZ Company
ABC Company
1234567 Company

How can i determine the position of the the first alpha character

Thank you
Austin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top