Find all cells within a column that begins with a specific string expression then replacing the date value in the cell in string format

[Halpplox]

I have no VBA coding experience except for recording macros hence I am stuck with this problem.

I have a spreadsheet with column J that contains string data type in all its cells.

Some of the cells contain string expression that begin exactly like this "The committee reviewed the case in Apr 2024*" and ends in a variety of ways.

What I need is for the date in such cells to be updated based on the today's month and year when I run the macro while everything else in the cell remains the same.

So If I ran the macro in May, then the string will be updated to "The committee reviewed the case in May 2024*" where * is the wildcard of whatever string the cell ends in.

Thanks in advance!

 

[Roncondor]

Can't you just do a "Find" and "Replace"?

 

[Akuini]

Some of the cells contain string expression that begin exactly like this "The committee reviewed the case in Apr 2024*"

Do you mean it always "Apr 2024" or it could be any month or year, such as "Jan 2024" or "Feb 2020"?