Extract Information from a cell.

C

Chad

Was just wondering if it was possible to extract partial information from a cell.
Ex.
A
1 Doe, John

How would I extract just the first name from cell 1,A to be used in another worksheet?

Thanks
 
P

Paul

Chad said:
Was just wondering if it was possible to extract partial information from a cell.
Ex.
A
1 Doe, John

How would I extract just the first name from cell 1,A to be used in another worksheet?

Thanks
Click to expand...

Assuming that there is only one space and you want what is to the right of
that space:
=RIGHT(A1,LEN(A1)-FIND(" ",A1))

For more information, look up "text functions" in Help.
 
L

LSMark

Try

=RIGHT(D3,LEN(D3)-SEARCH(",",D3,1)-1)

Replace cell D3 with whatever cell has the name.
 
Top