View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JSPaulk JSPaulk is offline
external usenet poster
 
Posts: 1
Default Replacing cell numbers but leaving leading zero

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?