Forum Discussion
How do I split up a cell containing a date?
I have an Excel document with over 4,000 rows in it, and many in one column are dates. I need to split it so I can run a PHP import, so it matches with our database. If I do =left(W6,2), I as...
Yes, I can see that it is CSV file
In the attached files, I select the Date in cell A2 > Click on Text to Column > Delimited > Checked Others with / in the box > Clicked Finished.
Kindly see the two pictures. It worked here...
