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

Thanks Ron,

Right I'm off to the shops to buy myself a fishing net - I'm catching
my own fishes from now on!

Thanks again,

Jon


On 28 Jan, 18:20, Ron Rosenfeld wrote:
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