Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel - merging contents in multiple cells
I have a column of 80 cells. Most of the cells contain text but some are blank. I would like to merge the contents of these 80 cells into one cell. The text from each cell needs to seperated by a semi-colon in the merged cell. I would also like to ignore the blank cells. I have looked at...- king1000
- Thread
- Replies: 3
- Forum: Microsoft: Office
-
Excel - automatically adding page breaks within data array
I am dealing with a large amount of data in Excel (5000 rows). Each row represents a person for which certain data is held (telephone, town, age, etc) I have sorted the data in ascending order by town and would now like to insert a page break after each town (so when I print I have a seperate...- king1000
- Thread
- Replies: 7
- Forum: Microsoft: Office
