Thread: Delete special character
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kiannie Kiannie is offline
external usenet poster
  
Posts: 3
Default Delete special character
"I have this symbol " ' " in the entire sheet
ie :
'0122344
'0123234
'8384392

May i know how to delete all the " ' " , which is the the first character of
the above ?
bear in mind all r followed with ZERO.
Reply With QuoteReply With Quote