Replace @@@ in Col B with data from Col A

[HowdeeDoodee]

I have several words in each cell Col B with some words in Col B prefixed with three @ symbols. I want to take the text in column A and prefix the three @@@ in column B with the column A data.

Another way to express this is I want to replace the three @ symbols in Col B with the text in Col A while leaving the @@@ as a separator.

Example:
ColA........................ColB........................................................ColC.........................
Cat............hi@@@box see@@@house do@@@toy................hi Cat@@@box see Cat@@@house do Cat@@@toy

 

[cherria]

=SUBSTITUTE(B1,"@@@",A1&"@@@")

should do what you want then copy it down the column

 

[HowdeeDoodee]

Thank you cherria. Working fine.

May your London fog be lifted.