Is there a way to delete all dates in excel
Closed
KElizabethF86
-
3 May 2011 à 12:13
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 6 May 2011 à 06:48
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 6 May 2011 à 06:48
Related:
- How to delete date in excel
- How to change date format in excel - Guide
- How to delete duplicates in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
- How to clear formatting in excel - Guide
- How to delete skype account - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
6 May 2011 à 06:48
6 May 2011 à 06:48
suppose data is in A1
select A1 .
click data-text to columns-
in step 1 choose
"fixed widt5h"
click next
in the second step remove the arrows (if they are there) by clicking on the arrow
EXCEPT THE LAST ARROW
click "finish"
see A1 and B1
select A1 .
click data-text to columns-
in step 1 choose
"fixed widt5h"
click next
in the second step remove the arrows (if they are there) by clicking on the arrow
EXCEPT THE LAST ARROW
click "finish"
see A1 and B1