How do I align cells in Excel onto one line?
 

Hi
I want to align cells in Excel onto one line.
Example data:

Column1 Column2 Column3 Column4
Row1 ABC
Row2 DEF
Row3 GHI
Row4 JKL

Should be

Column1 Column2 Column3 Column4
Row1 ABC DEF GHI JKL

Thanks a mil

Hi

Into B1 enter the formula
=(OFFSET(B1,COLUMN()-1,)
Copy the formula in B1 to right for as much columns as you have them in
table
Select all cells with formulas in row1, copy them, and replace with values
(PasteSpecial.Values)
Select the range from B2 to lower right corner of table, and clear all
entries (when you have in some cells formulas or values which must remain,
then probably you have to clear diagonal cellwise instead).

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"Mario" wrote in message
...
Hi
I want to align cells in Excel onto one line.
Example data:

Column1 Column2 Column3 Column4
Row1 ABC
Row2 DEF
Row3 GHI
Row4 JKL

Should be

Column1 Column2 Column3 Column4
Row1 ABC DEF GHI JKL

Thanks a mil

Select all the cells
Choose EditGo to, and click the Special button
Select Blanks, click OK
Choose EditDelete
Select 'Shift Cells up', click OK

Mario wrote:
Hi
I want to align cells in Excel onto one line.
Example data:

Column1 Column2 Column3 Column4
Row1 ABC
Row2 DEF
Row3 GHI
Row4 JKL

Should be

Column1 Column2 Column3 Column4
Row1 ABC DEF GHI JKL

Thanks a mil




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html