I would image so if you have commas in the text then for every comma
the text will be put in another cell.

that would be incorrect based on what it sounds like is being proposed. .

if a1 and b1 contain

a1: a,b,c
b1: d,e,f

and you did Files=Save As and selected CSV, it would be saved as

"a,b,c","d,e,f"

If you brought it back into excel, it would be placed in A1 and B1.


---------------------------------
if you want to change rows to columns, select the single column multiple row
area (assume starting in A1), do edit=copy

select b1 and do Edit=Paste Special and select transpose.

Now delete column 1

then File =Save As, and select CSV for the type.

--
Regards,
Tom Ogilvy



"mr_ben" wrote in
message ...

Who I Am Wrote:
Do you think if it will work:

I use "=CONCATENATE" in one cell and allow it to hold 25 cells. In
next
cell, I put second "=CONCATENATE" to hold another 25 cells....

So with 20 "=CONCATENATE"s, I can cover all my data, say, from A1:T1.

Then the question will be

Can I save it as CVS file where the entire first row is one record?


Yes and..

I would image so if you have commas in the text then for every comma
the text will be put in another cell.


--
mr_ben
------------------------------------------------------------------------
mr_ben's Profile:
http://www.excelforum.com/member.php...o&userid=37106
View this thread: http://www.excelforum.com/showthread...hreadid=568446