THANKYOU THANKYOU I scream with glee.
That worked in collating all the data into one cell Beege.
Im sure I can add spaces from here on in.
Thankyou once again

Beege wrote:
Use
=concatenate(Sheet2!B2,Sheet2!C2,Sheet2!D2Sheet2! E2)
Concatenate wants indivisual text (cells) between commas. I don't know why
you can't use a range...

Beege

Hi, I tried searching for an answer to this but couldnt find the one I
needed.
[quoted text clipped - 14 lines]
even
if it means slapping some sense into me ;-)

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200603/1