Excel 2000 Help

[plummet]

Im trying to merge cells together, but keeping the information... or an alternative to my problem..

i have cell A for example.. and i want cell b,c,d,etc information to fit underneath or together with Cell A...

would appreciate any assistance...

 

[ChilliGirl]

If you want one big cell from a few smaller ones...

Highlight cells, right click , select format cells, 2nd tab if i remember correct.... Click merge cells

 

[Pixelbender]

Hey - why don't you try this?

http://www.ehow.com/how_2189391_use-excels-concatenate-function.html

 

[plummet]

thanks antondiq... i tried mergin cells... i have infomation on each of the cells...i want them merged...but when i merge it, it only keeps the first cells information...

 

[Borrels]

If you want one big cell from a few smaller ones...

Highlight cells, right click , select format cells, 2nd tab if i remember correct.... Click merge cells

First add all the data into a single cell, then merge the cells you want to combine, then copy the data to the merged cell.

Use "&" or concat function to combine all data from various cells

 

[Twista]

ctr + enter on the first cell

 

[Grayson]

Hi Mate

To merge Cell A with other cells like B,C,D .select Cell A right click and select merge cell option.