Hi All,

I have list in following format:

A B C D E
0 1 2 3 4

Results wanted:

F
"0","1","2","3","4"


One more question is it possible to merge multiple column values into one
column without lost the values?

Thanks in advance.

While you posted in a programming newsgroup, the solution does not require
VB code to accomplish; simply copy/paste the following formula into F1 and
copy it down as needed...

=""""&A1&""","""&B1&""","""&C1&""","""&D1&""","""& E1&""""

--
Rick (MVP - Excel)



"ng6971" wrote in message
...
Hi All,

I have list in following format:

A B C D E
0 1 2 3 4

Results wanted:

F
"0","1","2","3","4"


One more question is it possible to merge multiple column values into one
column without lost the values?

Thanks in advance.