count terms in a cell

[zvika_1]

any idea how to count how many terms are in a cell ?

 

[Aladin Akyurek]

[...]

Is it possible now to point to any ward in a cell and switch between words ?
Example: A1 houses "Mr Excel Message Board"
New order: "Mr Excel Board Message"
[...]

Not fully tested but see...

Book2
	A	B	C	D
1
2	MrExcelMessageBoard	Board	MrExcel	BoardMessageMrExcel
3	MrExcelMessageBoard	Board	Board	MrExcelMessageBoard
4	MrExcelMessageBoard	MrExcel	Board	BoardMessageMrExcel
5	MrExcelMessageBoard	MrExcel	Message	MessageMrExcelBoard
6	MrExcelMessageBoard	Board	Message	MrExcelBoardMessage
7
Sheet1

The essential formula is...

=IF(B2<>C2,SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,B2,"@"),C2,B2),SUBSTITUTE(A2,B2,"@"),C2),"@",C2),A2)

where A2 houses an input sentence, B2 and C2 are words that must be exchanged.

Note. I did not seek to shorten it.

 

[stevebausch]

I have have need for this sort of stuff, was so happy to stumble upon the Microsoft page where code to simulate Split(), Replace(), Join(), etc was offered.

As newbie programmer many years ago, I was worried about math functions. Now it seems to me what really matters is the string functions you DON'T have to recreate.

 

[zvika_1]

Hi
=SUBSTITUTE(SUBSTITUTE(A1,"First_word","Second_Word"),"Second_Word","First_word",2
)

Instead using the word you use a formula so it could fitt for any word

Zvika

 

[zvika_1]

Hi
=SUBSTITUTE(SUBSTITUTE(A1,"First_word","Second_Word"),"Second_Word","First_word",2
)

Instead using the word you use a formula so it could fitt for any word

Zvika

 

[Aladin Akyurek]

On 2002-10-21 12:43, zvika_1 wrote:
Hi
=SUBSTITUTE(SUBSTITUTE(A1,"First_word","Second_Word"),"Second_Word","First_word",2
)

Instead using the word you use a formula so it could fitt for any word

Zvika

Hi,

Did you apply your "Instead using the word you use a formula so it could fitt for any word" to the table I published?

 

[zvika_1]

Aladin
Sorry but i think i missed you
let's assume that In "A1" houses the words: Teach Math Child
I need that each time i click.
the words will switch thier places.
click 1: Math Teach Child
click 2: Child Teach Child

Zvika