From: ng6971 on
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.
From: Rick Rothstein on
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" <ng6971(a)discussions.microsoft.com> wrote in message
news:1D73A671-CFBF-4CF3-B808-4E83558A3B04(a)microsoft.com...
> 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.