Combined Cell Value

  • Thread starter Thread starter ng6971
  • Start date Start date
N

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.
 
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&""""
 
Back
Top