View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John John is offline
external usenet poster
 
Posts: 2,069
Default Doing a replace with a wildcard charcter

I have a set of data in the form
(9)
(12)
(8)
(34)
(45)
I would like to search and append a '0' to single characters between brackets.

Searching on (?) finds the correct items but (0?) does not turn (9) into
(09). Can any one help?