Is it possible that the URL has an embedded lf at the end from entry on the source side?
I've created csv files comma/quoted that contained URLs and were quite long and didn't have any issues importing Them into excel as a .csv , at least not as breaking into two lines. George -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Thursday, February 09, 2012 11:06 AM To: U2 Users List Subject: Re: [U2] Building an Excel File Thanks George. I changed the tabs to pipes just to display them here. Normally I save as tab delimited with no surrounding character. Since the cell contents copies and pastes as 2 lines, I'm not sure whether these suggestions would solve my problem. Thanks again, Charlie On 02-09-2012 8:54 AM, George Gallen wrote: > Not sure if this helps... > > I noticed that you were showing pipe delimited lines... > If you rename your file from .csv to .txt > > Then from excel, you use the "Open" option, and then you can set the > delimiter to | > And also change the column types before it imports it, or have it skip a > column as well. > > George > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah > Sent: Thursday, February 09, 2012 9:46 AM > To: U2 Users List > Subject: Re: [U2] Building an Excel File > > While everyone is thinking about CSV and Excel, maybe I can get a > solution to a problem that's been plaguing me for a long time. > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
