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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We are using Quick Books and want to export to a Custom Label Quick Books
only exports to EXCEL in IIF format.
 
QUICK said:
We are using Quick Books and want to export to a Custom Label Quick Books
only exports to EXCEL in IIF format.
Click to expand...

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Best Gmail Backup Tool to use in 2025? 3
How to Export Gmail Emails to PST Format? 4
How to Convert EML to PST? 2
How do i concatenate two date fields. 1
Which is the best MBOX Converter Tool different formats conversion? 4
mulitple concatenate conditions 2
Separation of text - concatenate excel 1
de-concatenate? 5

Back
Top