Is there a way to delete all dates in excel

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

Is there a way to delete all dates in an excel workbook without deleting the actual cell they are in? For example, I have some cells that say "Company Name 3,400 SF 4/30/12". I would like a Macro or a single cell code that could return "Company Name 3,400 SF". The date is not always at the end of the string. Thanks!

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
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