Excel Find & Replace? or Formula?

[Angel_777_1]

Hi. I am using Microsoft® Excel® for Microsoft 365 MSO (16.0.14326.20384) 64-bit

Can anyone tell me how to "Find" all the cells in my worksheet that contain this date and time stamp format: 

2021-09-8T01:03:02+00:00

And then replace it with just the DATE in this format:"mm/d/yy".

Would that be an actual formula, or can I use the Find & Replace tool?

Thank you so much for your time!

Angel_777_1

[#2]

Hi. You will need a helper column with a formula that converts the text string to a numeric Excel date. When it is numeric, you may format it the way you like.
Assuming date string in column A;
=DATE(MID(T(@$A:$A);1;4);MID(T(@$A:$A);6;2);MID(T(@$A:$A);9;2))
or with ; replace by ,
=DATE(MID(T(@$A:$A),1,4),MID(T(@$A:$A),6,2),MID(T(@$A:$A),9,2))

Your example string seems like missing a zero so the formula is based on your screen shot.