Add $1.00 to XS-XL price and show in XXL price in the same cell

[tamalh]

I have an excel file with hundreds of prices. Each cell has 2 prices. XS-XL one price. XXL another price. I want to add $1.00 to all the XS-XL prices, show for XXL prices.
So basically, XXL prices will be +$1.00 than XS-XL prices.
I need to change this at a time, in all the hundreds of price cells. Is there an option?

Thank you for your kind help.

[Sam Capricci]

try this in C2 copied down... =LEFT(B2,11)&" "&"XXL-$"&RIGHT(MID(B2,SEARCH("XL-",B2),8),5)+1
you may have to change the formatting to match what you have, if you want the same spacing you'll have to add more spaces between the end of the LEFT(b2,11)&"here for more spaces"& etc.

[Sam Capricci]

BTW, your title says "in the same cell" - you can't do that w/o VBA or w/o VBA it would be a time consuming multiple find and replace.
with my formula, you could use it in col C, then copy the whole column, go to col B, do paste special - values and you'd have it done in two steps.

[josephteh]

Use FIND and REPLACE: highlight the range and hit Ctrl+H.

[tamalh]

Thanks for the reply. It helped.

Kind regards,