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!

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!