Is there a way to delete all dates in excel [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
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
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
797
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!