Forum Discussion

Copper Contributor

Jan 07, 2020

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...

excel

Formulas and Functions

simona6

Copper Contributor

Jan 07, 2020

It's a CSV File.

Abiola1

MVP

Jan 07, 2020

simona6

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...