how to copy the first word or two words from a cell containing a complete sentence to another cell
On 28 Jan 2007 09:06:21 -0800, "jonny" wrote:
Hi there,
I have a lot of cells containing descriptions of items - I need to
copy the first 1 or 2 words from each cell into another cell.
Any ideas greatly received!
Thank you,
Jonny
To return the first two words in cell A2:
=LEFT(A2,FIND(CHAR(1),SUBSTITUTE(A2&" "," ",CHAR(1),2))-1)
Note that within the SUBSTITUTE function:
A2 & " " <-- 2 spaces between quotes
," " <-- 1 space between the quotes
--ron
|