ExcelBanter - I know how to concatenate ,can one de-concatenate to split date?

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - I know how to concatenate ,can one de-concatenate to split date? (https://www.excelbanter.com/new-users-excel/37110-i-know-how-concatenate-can-one-de-concatenate-split-date.html)

QUICK BOOKS PROBLEM-

I know how to concatenate ,can one de-concatenate to split date?

We are using Quick Books and want to export to a Custom Label Quick Books
only exports to EXCEL in IIF format.

gls858

QUICK BOOKS PROBLEM- wrote:
We are using Quick Books and want to export to a Custom Label Quick Books
only exports to EXCEL in IIF format.

In the date column use the text to column feature under Data
on the menu bar. For the delimiter select / this will split
the date into three columns.

gls858

All times are GMT +1. The time now is 10:07 AM.