Combined Cell Value
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. |
Combined Cell Value
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. |
All times are GMT +1. The time now is 04:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com