Our Rank

Sponsored Link

Sponsored Link

Saturday, September 20, 2008

This post describe a scenario where you have list of first name and last name separated by space and you want to take only first name. In other words you have two word separated by text and you want result as only first part as result.

The following formula will separate the text part based on the position of space in the text.

You can see the formula in formula bar of image. Also the same is mentioned below

Formula

=LEFT(A2,FIND(" ",A2,1))

Also, do let me know your comments about this post and subscribe to us to receive latest updates via email