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," ","*")&"*"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to type each letter of the alphabet automatically in a specific color in Word? 0
Reorder $String1, $String2 to $String1 $String2? 2
Downgrading from Windows 11 1
Vlookyp fails due to space at the end 2
SQL script to solve problem 1
Word to Excel: Export comments with text and line number 0
New Dell PC 6
Help! Unlink headers not working even with section breaks 2

Back
Top