I have a lot of cells with Mon, Tue, Wed, etc.. in them. How do I remove the day from each cell?



Tue 10/1/24 Tue 10/1/24


Tue 10/1/24 Mon 10/28/24

Hello. Do your cells contain one or two dates? In the first case are they real dates ( right aligned in cell) or text looking like dates ( left aligned) ?

Post a small sample sheet ( no pics please). THx

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Do the values are in 4 cells for each row. Eg A2=Tue ,B2=10/1/24 ,C2=Tue,D2 10/1/24