if you mean somthing like rrr sss ttt
then =sheet1!A1&" "&sheet1!A2&" "&sheet1!A3
if you want it like
rrr
sss
ttt
then
=sheet1!A1&char(10)&sheet1!A2&char(10)&sheet1!A3
if you want it as
rrr

sss

ttt
then
sheet1!A1&char(10)&char(10)&sheet1!A2&char(10)&cha r(10)&sheet1!A3
"vronron" wrote:

Ok, I've set up multiple work sheets in a work book and have referenced cells
from, we'll call it worksheet 1, on worksheet three. I have them showing up
in the cell, however I am referencing three different cells from worksheet 1
into one cell in worksheet three and I am not sure how to get them to display
with spaces between them. If any body has any ideas I would be most
appreciative.