Replacing cell numbers but leaving leading zero

J

JSPaulk

I have a list of numbers that have a leading alphabetical character and then
1-3 zeros and then the rest of the numbers. I want to do a find and replace
to eliminate the leading alpabetical character, but keep all of the remaining
leading zeros. Even when I save the numbers as text, when I do the replace,
the leading zeros are gone. suggestions?
 
J

Jim Thomlinson

If it is just a single leading character then why not just use a formula like
this...

=MID(A2, 2, 256)
Where your text string is in A2.
 

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