Adding common text to multiple cells

[RodneyW]

I have multiple cells in the same row that currently have dates formatted as mmm yy as in Feb 24

I want to change these so they read Flag Feb 24 and Flag Jan 24 and Flag Dec 23 and so on. I've got about a dozen sheets that need this to be done on so manually doing it is laborious. The date portion of the value doesn't need to be mmm yy. It can be text. Is there a way to make these changes without manually doing it cell by cell by cell?

Thanks in advance.

 

[Asbestos_Jen]

Assuming your dates start in A1, put this in B1.

="Flag "&Text(A1,""MMM YY")

 

[RodneyW]

Assuming your dates start in A1, put this in B1.

="Flag "&Text(A1,""MMM YY")

YAHTZEE! That worked perfectly, thank you

 

[Asbestos_Jen]

Glad to help. Thank you for the feedback!