LEFT or RIGHT function but counting whole words

**Badvgood** · 10-04-2007, 09:59 AM

Hi all,

I need to use the LEFT & RIGHT function BUT not to count characters but whole words that are seperated by a space.

Any ideas on a formula / Function I can use?

Regards & Thanks in advance,

BVG

**VBA Noob** · 10-04-2007, 10:01 AM

Maybe

=LEN(TRIM(A1))-LEN(SUBSTITUTE(A1," ",""))+1

VBA Noob

**Badvgood** · 10-04-2007, 10:15 AM

That worked, as it always does when you give a solution. Thank you.

The other problem I have is........

I have a string of words in a cell (A1) and in A2 I would like the same string of words BUT seperated with a comma between each word.

Regards BVG