Sponsored Link

Sponsored Link

Saturday, September 20, 2008

Separate Text based on SPACE

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))

MS Excel, Text Separate
 

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

We assure you knowledge, not SPAM!

4 comments:

aShLeY said...

thanks buddy

Unknown said...

wow gr8 dost.....

thnx yaar......

plz keep it...

Unknown said...

THANKS YAAR, THIS IS A MAGIC FORMULA...........

Vishal Sahani said...

gud tip to all avid excel users.thanks buddy

Post a Comment