Thread: Replace Number
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default Replace Number

If there are no other instances of "00" you could use Find, Replace
"00", "0"

Gazz_85 wrote:
I have over 400 entries in a colomn which start with 0015...and then more
numbers.

how can easily edit on mass so that they now begin with only 015 ???

cheers