How Do I Add A Symbol To Each Word In A Cell When Referencing Another?

[Dhira]

For example

A1 has: confidential financial reports
I want cell B1 to show: +confidential +financial +reports


In other words, to "substitute: all words to have a "+" in front of it.
What formula do I use?

 

[DanteAmor]

How about:

varios 09abr2020.xlsm
	A	B
1	confidential financial reports	+confidential +financial +reports
2
Hoja3

Cell Formulas
Range	Formula
B1	B1	=TRIM(SUBSTITUTE(" " & A1," "," +"))

 

[Dhira]

How about:

varios 09abr2020.xlsm
	A	B
1	confidential financial reports	+confidential +financial +reports
2
Hoja3

Cell Formulas
Range	Formula
B1	B1	=TRIM(SUBSTITUTE(" " & A1," "," +"))

Yes, that's the one! Thanks so much.

 

[Peter_SSs]

Might you have any blank cells?

20 04 10.xlsm
	A	B
1	confidential financial reports	+confidential +financial +reports
2
3	One two three	+One +two +three
Add +

Cell Formulas
Range	Formula
B1:B3	B1	=IF(A1="","","+"&SUBSTITUTE(A1," "," +"))

 

[DanteAmor]

Yes, that's the one! Thanks so much.

Im glad to help you. Thanks for the feedback.