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
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!

Related:

1 response

venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
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