RE: Display issues

Giganews Newsgroups
Subject: RE: Display issues
Posted by:  BJ
Date: Wed, 22 Aug 2007

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)&char(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.

Replies

None

In response to

Display issues posted by vronron on Wed, 22 Aug 2007