Thread: Help with Macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Abbey Normal Abbey Normal is offline
external usenet poster
 
Posts: 16
Default Help with Macro

Hi. I used a macro once, when someone from here helped me. Sorry to say I
can't find my original post or document. Can someone with this:
Need a macro (it was vb last time)
To search a column and remove the double quote. It will always be in the
same character position, for instance, in column A, it will always end up in
position 27.
I have tried doing a simple edit and replace (replace it with nothing) but
then the text is replaced with scientic notation, even if I format with text.
Thank you for your help.