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
|