Hi Geoff -

Works perfectly, thanks.

ANTHONY

"Geoff Lord" wrote:

Try

=MID(A5,1,SEARCH(" ",A5))

Where text is in A5

Geoff


"carricka" wrote in message
...
Hi Folks -

Using Excel 2003, I'm looking for a formula, ultimately to mailmerge from
Word 2003, to extract a name from cells that contain a name and a number.
The names are of variable length as are the numbers. In all cases there
is a
space between the name and the number.
Examples a
Anthony 2
Ber 12
Philomena 123.

I've looked at LEFT and RIGHT and TRIM but can't see any way to go left
from
the space or right to the space.

Many thanks.
ANTHONY