Excel

Capuchin · #1 Jan 10, 2007, 12:27 AM

Any way to merge a number of cells into one cell, for example the title of many columns in a table??

colbtech · Jan 10, 2007, 12:45 AM

Try concat this function joins strings, you can add " " between arguements.
see attached zip

Capuchin · Jan 10, 2007, 01:00 AM

I mean merge the cells so that more than one column is headed by a single cell, I know you can do it with word tables, but I can't find the option in excell. Maybe you can't do it because spreadsheets are less of a presentation tool.. :/

colbtech · Jan 10, 2007, 01:51 AM

Select the 2 or more cells in the header row and then Format, Cells, Alignment, Check the Merge Cells.



At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to: Get free answers from experts in any of our 300+ topics. Accept money for answers that you provide. Communicate privately with other members (PM). See fewer ads. Sign Up!