| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Concatenate inside a vlookup | Excel Worksheet Functions | |||
| Concatenate in Pocket Excel | Excel Worksheet Functions | |||
| Concatenate cells in Pocket Excel | Excel Discussion (Misc queries) | |||
| Concatenate Function will not work | Excel Discussion (Misc queries) | |||
| Concatenate cells without specifying/writing cell address individually | Excel Discussion (Misc queries) | |||
Linear Mode
