I have a information in a cell the has text and a date. I want to extract the date from that cell and put it into its own cell, leaving the text in the current cell. I would like a simple way to do this without having to do it by hand. I would like to avoid the use of macro's.
Check 5/16/2008
Check 5/19/2008
Deposit 6/28/2008
Check 6/30/2008
This is how the current cell looks, I want to separate the date.
Thanks for the help.
Check 5/16/2008
Check 5/19/2008
Deposit 6/28/2008
Check 6/30/2008
This is how the current cell looks, I want to separate the date.
Thanks for the help.