| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
merge
data is imported from a text file as comma separated
There are 4 columns, however some data in column 2 have commas in the value. this leads to excel shifting the data into another columns Eg. column 3 has dates in it. but due to that extra comma in the column 2, the text in column 2 is shifted in the column 3 (date) and so with column 4. Is there a way to macro this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merge & Center function is turned off...how do I turn it back on? | Excel Worksheet Functions | |||
| Different graphic for each record in mail merge document | Charts and Charting in Excel | |||
| How do I do an excel merge like a word mailmerge with another exc. | Excel Discussion (Misc queries) | |||
| Serious Mail Merge Problem | Excel Discussion (Misc queries) | |||
| Extract Data for Mail Merge | Excel Discussion (Misc queries) | |||
Threaded Mode
