Thread: Extract the first few characters
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MC_blur
 
Posts: n/a
Default Extract the first few characters
Hi,
I have a excel document contain over 100 records, can i know how to extract
the character from whole column B?

Example:
1. NMBJD1234QA - NMBJD
2. SQA1093W - SQA

Thanks in advanced...
Reply With QuoteReply With Quote