Hi!

Try this array formula. Entered with the key combo of CTRL,SHIFT,ENTER:

=LEFT(A1,MATCH(1,(CODE(MID(A1,ROW(INDIRECT("1:"&LE N(A1))),1))47)*(CODE(MID(A1,ROW(INDIRECT("1:"&LEN (A1))),1))<58),0)-1)

Will return everything to the left of the FIRST NUMBER (digit) found in the
string.

Biff

"gbeard" wrote in message
m...
Biff,
Can I use the FIND command to locate a number (not a specific number, but
rather, the first number) within a cell? This would solve part of my
problem, if I can extract everything before the first number I would end
up with the clients name.

--
Gary Beard