Thread: Extra string before a specific character
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sandra Sandra is offline
external usenet poster
  
Posts: 39
Default Extra string before a specific character
I have a column of data, like CA-, THAMES-, AWR-. etc. I want to pull all
data before the "-". It could be 2 characters to 6. Any ideas? Thanks.
Reply With QuoteReply With Quote