N news.microsoft.com Jun 6, 2005 #1 If I have a cell that contains a person's full name, how do I get just their first name in another cell. Thanks, Mike
If I have a cell that contains a person's full name, how do I get just their first name in another cell. Thanks, Mike
N news.microsoft.com Jun 6, 2005 #3 Thanks Harald! Harald Staff said: Hi Mike =LEFT(A1,FIND(" ",A1)-1) HTH. Best wishes Harald Click to expand...
Thanks Harald! Harald Staff said: Hi Mike =LEFT(A1,FIND(" ",A1)-1) HTH. Best wishes Harald Click to expand...