View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default how to copy the first word or two words from a cell containing a c

On 28 Jan 2007 09:44:48 -0800, "jonny" wrote:

Wow, thanks guys, any idea how to adapt this to do the first 3 and 4
words?

Thanks again.


All you need to do is modify my function appropriately.

It would be a good idea for you to work through it and understand how it works.
Then you'd be able to figure this out on your own.

=LEFT(A2,FIND(CHAR(1),SUBSTITUTE(A2&
REPT(" ",NumWords)," ",CHAR(1),NumWords))-1)

where NumWords is the number of words you wish to return.


Give a man a fish and you feed him for a day. Teach a man to fish and you feed
him for a lifetime.
Chinese Proverb


Variations:

Give a man a fish and you feed him for a day; teach him to use the Net and he
won't bother you for weeks!

Give a man a fish and he'll eat for a day. Give a man religion and he'll starve
to death praying for a fish.

Give a man a fish, and you feed him for a day; teach a man to fish, and you get
rid of him on weekends.

Sell a man a fish, and he can eat for a day, teach a man to fish, and you lose
a great business opportunity? Karl Marx


There is a fine line between fishing and just standing on the shore like an
idiot. Steven Wright
--ron