Hi

It appears that you want to extract everything to the left of the first
digit found in the string?

Entered as an array using the key combo of CTRL,SHIFT,ENTER:

=LEFT(A1,MIN(IF(ISERROR(1*(MID(A1,ROW(INDIRECT("1: "&LEN(A1))),1))),255,ROW(INDIRECT("1:"&LEN(A1) ))))-1)

Biff

"MC_blur" wrote in message
...
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...