Combining two columns and modifying the data in one formula?

[BigHungarian]

Hi everyone,

Please see attached Test File for better clarity on what I am looking to do.
Join Column A & B but modify the data. Column A contains a date range and I would like to modify the data to reflect just the MM and DD preceded with the letter B and a colon such as this. "B:"
Column B has a value in it that needs the letter S and a colon such as. "S:"

Is this possible?

Thanks for your help.

[dosydos]

In C2 then drag down:

Please Login or Register  to view this content.

[Glenn Kennedy]

Or, since you have O365, use a dynamic array:

="B:"&TEXT(A2:A18,"mmdd")&" S:"&B2:B18

[BigHungarian]

Awesome Thank You!

[BigHungarian]

Thanks very much for your assistance! Much appreciated.