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!