I have an excel sheet like this:::: ___________________________________________________________________ in the first cell: 1:08:00 AM in the second cell: TEXT in the third cell: 1:15:00 AM in the fourth cell: TEXT in the fifth cell: 1:20:00 AM in the sixth cell: TEXT..........................and so on till 800 rows like this. ___________________________________________________________________ now I have 800 rows like this. How can I remove only time value 1:08:00 AM from all 800 rows so that I can extract only TEXT values.
The video is really helpful.
Thanks for the video, Pls let us know how to extract single cell containing multiple dates.
Very helpful. This is the video I was looking for
You are welcome 🤗
I needed this badly .thank u
wow Thank you :)
Welcome!
I have an excel sheet like this::::
___________________________________________________________________
in the first cell: 1:08:00 AM
in the second cell: TEXT
in the third cell: 1:15:00 AM
in the fourth cell: TEXT
in the fifth cell: 1:20:00 AM
in the sixth cell: TEXT..........................and so on till 800 rows like this.
___________________________________________________________________
now I have 800 rows like this. How can I remove only time value 1:08:00 AM from all 800 rows so that I can extract only TEXT values.
If you are using Excel 365
Example: =FILTER(B3:B8,ISTEXT(B3:B8))