I need to add a * before and after each word. Can anyone help me in doing
this?

Thank you!

If you have a phrase like:

the cat sat on the mat

in A1, and this formula in B1:

="*"&SUBSTITUTE(A1," ","* *")&"*"

then you will end up with:

*the* *cat* *sat* *on* *the* *mat*

Is that what you want? You can copy the formula down if you have other
phrases in column A. With only a single word in A1, like "test", the
formula will give you "*test*" (without the quotes).

Hope this helps.

Pete

On Nov 8, 1:44*am, Brianna wrote:
I need to add a * before and after each word. *Can anyone help me in doing
this?

Thank you!

Hi,

If each word is in its own cell you could use

="*"&A1&"*"

Or if you want to loose the spaces between word in a multi-word cell

="*"&SUBSTITUTE(A9," ","*")&"*"


--
Thanks,
Shane Devenshire


"Brianna" wrote:

I need to add a * before and after each word. Can anyone help me in doing
this?

Thank you!