Combined Cell Value

[ng6971]

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.

 

[Rick Rothstein]

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&""""