LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
nnappy
 
Posts: n/a
Default Importing CSV files


Hi Everyone,

I'm trying to import a csv file that has a field where users post
comments online. When I import it though, Excel reads through the
comments and creates separate columns whenever a user uses a comma in
their comment which from what I understand isn't supposed to happen
because the comments are enclosed like "....".

I thought that Excel only creates columns when the commas lie outside
two pairs of ", any suggestions??


--
nnappy
------------------------------------------------------------------------
nnappy's Profile: http://www.excelforum.com/member.php...o&userid=35570
View this thread: http://www.excelforum.com/showthread...hreadid=553309

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing CSV files into Excel Doug Excel Discussion (Misc queries) 9 August 24th 05 08:22 PM
importing multiple text files into the same worksheet Mike D Excel Discussion (Misc queries) 4 July 15th 05 10:39 AM
Importing multiple Text files into Excel 2003 JMA Excel Discussion (Misc queries) 5 May 5th 05 09:48 PM
importing multiple text files URGENT!!! HELP tasha Excel Worksheet Functions 0 December 19th 04 04:26 PM
importing multiple text files??? tashayu Excel Discussion (Misc queries) 0 December 19th 04 02:43 PM


All times are GMT +1. The time now is 02:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"