Thread: Replacing numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Randy B. Randy B. is offline
external usenet poster
  
Posts: 3
Default Replacing numbers
I have a spreadsheet which contains 6 digit numbers (i.e.209111, 209112,
209113).
I would like to perform a bulk replace for just the first 3 numbers.
Turn 209*** into 210***.
Any suggestions?
Thanks,
Randy
Reply With QuoteReply With Quote