Hey guys, I am new to Excel. have date and time in same coloumn (Dec 20 2005 12:30PM). How do I convert it into 12/10/2005 12:30PM.
There is some times 1 sometimes 2 spaces between month and date and year. What formula should I use.
Thanks in advance
DEE2005
There is some times 1 sometimes 2 spaces between month and date and year. What formula should I use.
Thanks in advance
DEE2005