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

  • Thread starter QUICK BOOKS PROBLEM-
  • Start date
Q

QUICK BOOKS PROBLEM-

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

gls858

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
 

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

How can I install Publisher in 365 Enterprise? 1
How can I find paragraph breaks that are not preceded by a period? 0
Word 2016 - Difficulties Learning Style Creation/Application 0
VBA - exporting serial letters to single documents 0
How do i concatenate two date fields. 1
ASK Field Formatting 1
How to count the numbers in a Word document? 0
Outlook main UI edit needed, report spam button creation... 0

Top