Thread: Removing character in a string
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MikeL MikeL is offline
external usenet poster
  
Posts: 14
Default Removing character in a string
When importing an excel file the character " ' " appears in front of a zip
code;

'85004 this hinders the vlookup formula. How can I remove this character en
mass?
Reply With QuoteReply With Quote