HOW TO INSERT A * BEFORE AND AFTER EACH WORD

  • Thread starter Thread starter Brianna
  • Start date Start date
B

Brianna

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
 
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," ","*")&"*"
 
Back
Top