MS Excel: Nesting SUBSTITUTE & CONCATENATE Formula within Text String

[Miaka3]

I would like to know if it's possible to combine a nested SUBSTITUTE and CONCATENATE formula or similar to add/insert a Character within text string


I have a column containing keywords (Cell: A2:A3) that I would like to place a unique character ("$") within the text string in front of each of the keyword discovered within the text.


Keywords:
A2: New York, NY
A3: (250) 888-0000


OLD TEXT (Cell: B2)
John X. Doe New York, NY (250) 888-0000 johndoe@myemail.com


OUTPUT TEXT (Cell: C2)
John X. Doe $New York, NY $(250) 888-0000 johndoe@myemail.com

 

[Kuljack]

=SUBSTITUTE(SUBSTITUTE(A1,"New York","$New York"),"(250) 888-0000","$(250) 888-0000")

 

[Miaka3]

Kuljack, thank you for your reply... Your solution does work, but this method would require that the input Data is manually inputted into the formula versus reading from the cell/Column containing Keywords.

I was able to come up with a formula that does work... take a look and let me know.

=SUBSTITUTE(SUBSTITUTE(B2,A2,CONCATENATE("$",A2)),A3,CONCATENATE("$",A3))

 

[Kuljack]

My apologies, I overlooked that initial callout regarding A2:A3. Concatenate isn't all the necessary but is fine. I would lock those cells down however if you're referencing more cells in column B.

=SUBSTITUTE(SUBSTITUTE(B2,$A$2,"$"&$A$2),$A$3,"$"&$A$3)