Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have exported data from a database into a delimited CSV. file and opened
it in excel. The database has a field where you can enter a description for an item. It appears that if the description has a return or is over 32 characters it creates a new field. On the worksheet you will see duplicate cells in column A (barcode #'s) with different descriptions in column B. This makes sorting the worksheet very difficult and almost impossible for reporting or mantainancing to import back into the database. Is there a way to identify all the duplicate cell A'S and then have their corresponding cell B's merge and still retain their text? |