Display issues
 

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.

Display issues
 

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.

Display issues
 

Click in the cell on Sheet3 that will receive the data from Sheet1.
Type in an equal sign ( = ),
Navigate to Sheet1, and click in the first cell containing the data,
*IN THE FORMULA BAR*, type this at the end of what you see displayed the
&" "&
so that it might look like this:

=Sheet1!A1&" "&

Then, click in the 2nd cell of data, and add the same characters, to look
like this:

=Sheet1!A1&" "&Sheet1!C1&" "&

Finally, click in the final cell, and hit <Enter, and it should look like
this:

=Sheet1!A1&" "&Sheet1!C1&" "&Sheet1!E1
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"vronron" wrote in message
...
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.

Display issues
 

Thanks! I knew it had something to do with quotations but the things I tried
weren't working and my brain was just refusing to cope.

"Ragdyer" wrote:

Click in the cell on Sheet3 that will receive the data from Sheet1.
Type in an equal sign ( = ),
Navigate to Sheet1, and click in the first cell containing the data,
*IN THE FORMULA BAR*, type this at the end of what you see displayed the
&" "&
so that it might look like this:

=Sheet1!A1&" "&

Then, click in the 2nd cell of data, and add the same characters, to look
like this:

=Sheet1!A1&" "&Sheet1!C1&" "&

Finally, click in the final cell, and hit <Enter, and it should look like
this:

=Sheet1!A1&" "&Sheet1!C1&" "&Sheet1!E1
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"vronron" wrote in message
...
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.

Display issues
 

Appreciate the feed-back.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"vronron" wrote in message
...
Thanks! I knew it had something to do with quotations but the things I
tried
weren't working and my brain was just refusing to cope.

"Ragdyer" wrote:

Click in the cell on Sheet3 that will receive the data from Sheet1.
Type in an equal sign ( = ),
Navigate to Sheet1, and click in the first cell containing the data,
*IN THE FORMULA BAR*, type this at the end of what you see displayed
the
&" "&
so that it might look like this:

=Sheet1!A1&" "&

Then, click in the 2nd cell of data, and add the same characters, to look
like this:

=Sheet1!A1&" "&Sheet1!C1&" "&

Finally, click in the final cell, and hit <Enter, and it should look like
this:

=Sheet1!A1&" "&Sheet1!C1&" "&Sheet1!E1
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"vronron" wrote in message
...
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.