You will need the data in A1 to be held elsewhere say b1.
Then A1 will have the following formula:

=B1&", "&C1&", "&D10&", "&D1&", "&D2", "&D3", "&D4", "&D5

You will need to make sure there is a space after the
comma otherwise it will all run together as one long group
of letters and numbers.

BOL
David C
-----Original Message-----
Hi,

I have one question,


Input:

A1 contains: Selvam K
C1 contains: Frank
D10 contains: gdselva
d1:d5 contains: 10, 20, 30, 40, 50


Output:
A1 contains:
Selvam K, Frank, gdselva, 10, 20, 30, 40, 50


The selection should be using Ctrl + a1, c1, d10, d1:d5
this sequence.
The output should be merged all the cell values and
display into the
first selected cell.


Can you help me I to do it.


Regards,

Selvam K


---
Message posted from http://www.ExcelForum.com/

.