Hi,

I have a problem for someone to solve :-)

I am trying to write a formula for ecxel to pull data from a range of
cells and place them all in one cell..

See Below

A B C D E F G
1
2 1 2 3 4 5 6
3 123456
4
5 A B C D E F
6 ABCDEF
7

I want the contents of the 6 cells to be in one cell as if copied
pasted next to each other?

Has anyone got any idea on this?


--
whitieklf
------------------------------------------------------------------------
whitieklf's Profile: http://www.excelforum.com/member.php...o&userid=37178
View this thread: http://www.excelforum.com/showthread...hreadid=568931