Re: Splitting cells

Giganews Newsgroups
Subject: Re: Splitting cells
Posted by:  Peo Sjoblom (terre…@mvp.org)
Date: Tue, 14 Oct 2003

One possible way

in a third column

=A1&"/"&B1

copy down as long as needed

adapt to fit your cell ranges

note that this will be text values and not fractions

--

Regards,

Peo Sjoblom

"Jimmy" <jim…@hotmail.com> wrote in message
news:0e5101c39255$343db2c0$a40128…@phx.gbl...
> I have two sets of data that i would like to put in one
> cell.  Is there anyway i can split the cell diagonally and
> have one data set above the diagonal line and one below?
>
>  x/y
> 1/2
> 3/4
> 5/6
>
> something like that?
>
> THANKS A LOT

Replies

None

In response to

Splitting cells posted by jimmy on Tue, 14 Oct 2003