Sponsored Link

2011-11-11

Sponsored Link

2011-11-11

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!

Bookmark and Share
Posted by Sarfaraz Ahmed at 12:31 PM
Labels:

4 comments:

aShLeY said...

thanks buddy

http://findsarfaraz.blogspot.com/2008/09/separate-text-based-on-space.html?showComment=1222361820000#c4245767254202764056'> September 25, 2008 at 10:27 PM
Anonymous said...

wow gr8 dost.....

thnx yaar......

plz keep it...

http://findsarfaraz.blogspot.com/2008/09/separate-text-based-on-space.html?showComment=1222443660000#c4396432699713297751'> September 26, 2008 at 9:11 PM
Unknown said...

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

http://findsarfaraz.blogspot.com/2008/09/separate-text-based-on-space.html?showComment=1222709700000#c1223409734732311614'> September 29, 2008 at 11:05 PM
Vishal Sahani said...

gud tip to all avid excel users.thanks buddy

http://findsarfaraz.blogspot.com/2008/09/separate-text-based-on-space.html?showComment=1229853480000#c877594626962569896'> December 21, 2008 at 3:28 PM

Post a Comment

Subscribe to: Post Comments (Atom)