Combine cell data into one cell

L

LY

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: Intel

I need to combine the text in several cells into one cell on a spreadsheet. Is there a function that can do this? (I can cut and paste, but it would take too long for this spreadsheet.) Is there a way to highlight the cells that I need to combine and combine the text from them into the first cell?
 
C

CyberTaz

One Option: Examine Excel Help on the CONCATENATE function.

HTH |:>)
Bob Jones
[MVP] Office:Mac
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging data from 2 workbooks 1
combine all sheets into one 0
cell display 2
Previous Cell Comments Appearing when Mousingover cells in one column 2
Linking data in MS Word into Excel 5
How does excel note a newline (ie new line but in same cell) 3
Combining 2 seperate spreadsheet files 0
double spacing table in excel 1

Top