EXTRACT TEXT FROM TEXT STRING

C

carricka

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 are:
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
 
B

Barb R.

Try this:

=MID(A1,SEARCH(" ",A1,1)+1,LEN(A1)-SEARCH(" ",A1,1))

You could also parse the data using DATA -> TEXT TO COLUMNS
 
C

carricka

Hi Barb,

This gives me the number instead of the name. It's not what I want but is
most useful anyway. Geoff has supplied a formula that gives me the name.
Thanks very much for your time.

ANTHONY
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top