Forum Discussion
Excel Find & Replace? or Formula?
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: 202...
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.
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.