View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lisa W. Lisa W. is offline
external usenet poster
 
Posts: 15
Default Find and Replace

I'm working on a spreadsheet with APN#'s. I need to change it from seven
38-21-200 characters to ten, something like this 038-21-20000. Any
suggestions on a wildcard to add a zero before and zeros after? Thanks.
--
Lisa W.