Spliting and combing text down rows in Excel 2007

G

Glenn in London

There was a button that I could put on the quick access tool bar in old Excel
that allowed me to split and combine text over a number of rows depending on
how many columns I wanted the text to go across.

This isn't any of the merge or current justify functions in 2007 and I can't
see that any of the current functions allow me to do this.

It was really helpfull when writing reports in Excel and formating things to
make them look neat but I can't find it in 2007.

Any ideas?

Thanks!
 
J

JR Hester

Glenn,

Are you thinking of the Text to columns function. It splits text into
separate coulumns, but I don't know that is adds text together. Text to
Column is on the data tab of teh ribbon in 2007.

HTH
 

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

Pivot Chart - Excel 2013 - Rotating Second and Third Lines of text onthe Horizontal Axis 0
Where is the justify function in Excel 2007? 3
Freeze multiple rows/columns in Excel 2007 11
Excel 2007 with no increase in rows and columns 2
Is Paste Special HTML broken in Excel/Office 2007? 1
Deleting rows in Excel 2007 using filters 1
Excel 2007 Text Boxes 3
Cut Non Adjacent Rows in Excel 2007 1

Top