Extract Information from a cell.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Try

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

Replace cell D3 with whatever cell has the name.
 
Back
Top