excell problems

  • Thread starter Thread starter Guest
  • Start date Start date
<Alt> <Enter>

--

HTH,

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

how can i put TWO LINES OF NUMBERS IN ONE CELL
 
Hi,

If you want to put two lines of data into one cell, use the concatenat
function. This joins up to 30 cells of information. The easy way is:

=A1&A2

The slow way is:

=CONCATENATE(A1,A2)

If you want to view the data on two lines in the cell, format the cell
for Word Wrap (Format menu, Cells, Alignment, Wrap Text) and make th
column as wide as the first word.

Hope this is what you want.

All the best,


Rol
 
Back
Top