Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
merging columns
I am trying to import data from Excel into QB 2006 Premier. Data is in
Excel. I store the customer names in two different columns. Example: 1st name is column a, last name is column b, However Quickbooks wants the names in one field in some columns like the Name Contains, Contains fields. Is there a way to get Excel to join both columns? If so how? And how to I then get it to do the above, but last name, first name? Same for getting City, State Zip Country from 4 different columns into one column? Finally, same thing with credit card expiration date? I have the date stored as 04/08. How Can I get Excel to move the 04 to one column and 08 to another? Thanks very much in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging Columns | Excel Worksheet Functions | |||
How do I wrap Excel columns in a printout? | Excel Discussion (Misc queries) | |||
merging text columns | Excel Discussion (Misc queries) | |||
WRAP a text line over several columns without merging cells | Excel Worksheet Functions | |||
Merging columns of data | Excel Discussion (Misc queries) |