Spliting and combing text down rows in Excel 2007
 

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!

Spliting and combing text down rows in Excel 2007
 

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

"Glenn in London" wrote:

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!