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...
In the example of the attached workbook:
1. Select cell A2
2. Click on Text to Column in Data tab
3. Select Delimited and click Next
4. In Step 2, check Other. In the Order box, put in /
5. In Step 3, choose destination cell
6 click Finish
Thats all
1. Select cell A2
2. Click on Text to Column in Data tab
3. Select Delimited and click Next
4. In Step 2, check Other. In the Order box, put in /
5. In Step 3, choose destination cell
6 click Finish
Thats all
I did. But the result was a number that was none of those in the original cell.
- Hello,
Kindly re-save the workbook as Excel Workbook and try again..
