Hi Max

What do you mean by 'align the text and the numbers into one cell"? Can you
post some plain text examples of what you have - and also what you would
like?

Cheers.
Andy.

"Max_power" wrote
in message ...

Hello,

I apologise for serial posting but I can now identify my problem.
I'd like to concatenate two columns of data. In the first column I have
a lot of text, obviously there is some text that will be longer than
others. In the second column I have a lot of numbers identifying the
text in the first column.
I'd like to allign the text and the numbers into one cell.
I know I can do this with the indent button on the toolbar but I have a
lot of data and this would prove to be a tedious task if I were to
approach it like so.
Can anyone suggest any other methods.

Thank you very much in advance

Max


--
Max_power
------------------------------------------------------------------------
Max_power's Profile:
http://www.excelforum.com/member.php...o&userid=32255
View this thread: http://www.excelforum.com/showthread...hreadid=525763