View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Colin Colin is offline
external usenet poster
 
Posts: 86
Default Find and Replace with wildcards?

Hello,

I have data in a worksheet that has some number and some letter values
sometimes followed by an asterisk.
I am trying to find all entries of a number followed by an asterisk and
format the cell and remove the asterisk.
I am halfway there using find and replace but starting to think this may not
be the best way to do it.
Any help greatly appreciated. Thanks