LinkBack URL
About LinkBacks
In column A i have sentences which of it contain different number of words like this:
running shoes for women
walking shoes for kids size 12
men sneakers and boots
I want to leave only first two words of every sentence. How can i do this?
Thanks!
In column A i have sentences which of it contain different number of words like this:
running shoes for women
walking shoes for kids size 12
men sneakers and boots
I want to leave only first two words of every sentence. How can i do this?
Thanks!
Last edited by emil9216; 02-01-2013 at 04:25 AM.
=LEFT(TRIM(A1),SEARCH("@",SUBSTITUTE(TRIM(A1)," ","@",2))-1)
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
It works but, for example, if i want to leave the first 5 words and some of the sentences contain less than 5 words it change the sentences to this: #VALUE!
=LEFT(TRIM(A1),SEARCH("@",SUBSTITUTE(TRIM(A1)&" "," ","@",5))-1)
where there are 5 spaces between the quotes TRIM(A1)&" "
Thanks, but it still doesn't work.
example.xlsx
Try this adapted version of ChemistB's formula
Please Login or Register to view this content.
Life's a spreadsheet, Excel!
Say thanks, Click *
You didn't put 5 spaces between the quotes. See attached
Thanks! It works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks