Add a character before each word in a cell

**jas225** · 12-29-2010, 08:36 PM

Hi, I would like to add a "+" sign before each word within a bunch of cells. How would I be able to do this with a formula? Should I split up the cell into its component words somehow, then add the +, then concatenate them together? Any help would be appreciated. Looking to do this for an Adwords account to turn keywords into modified broad match keywords.

Thanks much.

Jim

**MarvinP** · 12-29-2010, 08:39 PM

Hi jas 225 and welcome to the forum.

Could you use the Replace function and replace each space with " +"?

**Ron Coderre** · 12-29-2010, 08:40 PM

Can you post some sample cells and what you want the result to be?

**Marcol** · 12-29-2010, 09:26 PM

Try this demo workbook
In B1

Please Login or Register  to view this content.

Is that what you mean?

**wfoody** · 03-26-2014, 03:29 PM

This helped a ton. But you would really want

Please Login or Register  to view this content.

**FDibbins** · 03-26-2014, 03:34 PM

wfoody, this thread is over 3 years old, I doubt the OP is still monitotring it now.

Good catch though, if they had wanted to add + before the 1st word

**davidneville** · 02-15-2017, 08:03 PM

Originally Posted by wfoody

This helped a ton. But you would really want

Please Login or Register  to view this content.

Amazing. Thanks. I just used this in an excel sheet. Probably saved me hours of legwork. THANK YOU! THANK YOU! THANK YOU!

**FDibbins** · 02-15-2017, 08:24 PM

David, thanks for the feedback on this, Im happy that it was able to help you

**seogmr** · 08-07-2018, 12:40 AM

Hello guys.

I know this is an old thread but I'm looking exactly for this.
I tried your suggestions but it didn't work.

Something changed?

Thanks

**FDibbins** · 08-07-2018, 01:35 AM

seogmr welcome to the forum

As I said in post #Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.