I have a very long list of names/affiliations in Excel 2003 file that I want to use to create labels on a Dymo Labelwriter. The Labelwriter software has a "paste and print" function -- you can copy from one application and paste directly into the tray icon. You don't create a single file with all the names -- it essentially just overwrites the last entry with the next one. This is handy at an event when checking in people -- find their names, print a label.
This works fine on cells where there is a single line of text, but where the there are two lines -- and apparently alt-ent was used to enter a hard return -- the text pastes with quotation marks at beginning and end.
This will be cumbersome to deal on-site, where someone would have to go into each label and remove the quotation marks before printing. Is there some better way to deal with this?
This works fine on cells where there is a single line of text, but where the there are two lines -- and apparently alt-ent was used to enter a hard return -- the text pastes with quotation marks at beginning and end.
This will be cumbersome to deal on-site, where someone would have to go into each label and remove the quotation marks before printing. Is there some better way to deal with this?
