Replace multiple specific pieces of text in a cell

[JTH94BT]

Hi everyone,

I'd like to be able to find and replace multiple strings of text in a single cell using one formula.

e.g.

cell A1 = "Daytime 20.50, Evening and Weekend 11.75"

cell A2 old text = 20.50
cell A3 old text = 11.75
cell B2 new text = 22.50
cell B3 new text = 12.50

What formula can I write to achieve the following outcome in cell B1? = "Daytime 22.50, Evening and Weekend 12.50"

 

[JTH94BT]

Hi everyone,

I'd like to be able to find and replace multiple strings of text in a single cell using one formula.

e.g.

cell A1 = "Daytime 20.50, Evening and Weekend 11.75"

cell A2 old text = 20.50
cell A3 old text = 11.75
cell B2 new text = 22.50
cell B3 new text = 12.50

What formula can I write to achieve the following outcome in cell B1? = "Daytime 22.50, Evening and Weekend 12.50"

Don't worry guys I've worked it out! I used =SUBSTITUTE(SUBSTITUTE(A1,A2,B2),A3,B3)

 

[Joe4]

Formula in cell B1:

=SUBSTITUTE(SUBSTITUTE(A1,A2,B2),A3,B3)

 

[Joe4]

I see that you found the answer while I was typing up my reply.
Nice job!