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!