Previous Topic Next Topic

Is there a way to delete all dates in excel

Closed
KElizabethF86 - May 3, 2011 at 12:13 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - May 6, 2011 at 06:48 AM
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 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
May 6, 2011 at 06:48 AM
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
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses