I have a csv file that is a download from an online form. The online form
has several text boxes in which users can enter as much info as they like.
When I export the records into the csv file the data in those text boxes do
not get thrown into one column but rather sometimes take up more than one
column (I think its becuase the user hits the "enter" button while they are
in the text box).

Is there a way once in Excel that I can get the data for the text boxes to
drop into one column only?

Please let me know if clarification is needed. THanks!

--
--coastal

I would think the the easiest solution would be to have the program that creates
the csv file to fix those "enter" characters.

Maybe you(?) can change those characters to linefeeds (alt enters in excel).



coastal wrote:

I have a csv file that is a download from an online form. The online form
has several text boxes in which users can enter as much info as they like.
When I export the records into the csv file the data in those text boxes do
not get thrown into one column but rather sometimes take up more than one
column (I think its becuase the user hits the "enter" button while they are
in the text box).

Is there a way once in Excel that I can get the data for the text boxes to
drop into one column only?

Please let me know if clarification is needed. THanks!

--
--coastal

--

Dave Peterson