I have a spreadsheet where I would like to merge the cells in each row
into one cell, excluding the first three columns.
So columns A to C I don’t want to merge.
However, I would like to merge C1 to M1 into one cell in row one and so
on, for example.
The problem is that in each row the number of cells that have data in
them to be merged will vary.
So I’m asking for a formula that is capable to search each row and
merge all data, after column C.
For each merged cell I would like to have some sort of separator, say a
comma, to distinguish the merged cells.
I hope that this hasn’t been asked before, or that this hasn’t been too
confusing.
Thanks for any help
--
sonic
------------------------------------------------------------------------
sonic's Profile:
http://www.excelforum.com/member.php...o&userid=23060
View this thread:
http://www.excelforum.com/showthread...hreadid=387698