Extract Information from a cell.

[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

 

[Andy B]

Chad

Have a look at Data / Text to columns.

Andy.

 

[Paul]

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

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.

 

[LSMark]

Try

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

Replace cell D3 with whatever cell has the name.