View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ann ann is offline
external usenet poster
 
Posts: 210
Default Alter Account numbers

I have a list of approx 9000 account numbers that are in the format:

#####-###-### (ex: 35000-455-876)

I would like to add "03-" to the front of the numbers and delete the last
"-###", so the final format would be:
03-#####-### (ex: 03-35000-455)

Any suggestions? I can't seem to figure out the concantenate function.

Thanks!
Ann