You're welcome. Thanks for the feedback!

Biff

"Carrguy" wrote in message
...
That worked great thank you Biff for the great help.

"Biff" wrote:

"Carrguy" wrote in message
...
That worked out wonderfully. I have one more question. I wanted to keep
my
orginial information all in cell A1 as well. Is there a way to do that.
Thanks for all the help!

OK, believe it or not, it's easier to parse A1 using Text to Columns and
then "rebuild" the original entry.

You can insert a new column A.

Then, enter this formula in A1:

=B1&CHAR(10)&C1&CHAR(10)&D1&CHAR(10)&E1

Format the cell to wrap text:

Select the cell
Goto the menu FormatCellsAlignment tab
Under Text Control, select Wrap text
OK out

You may have to widen the column to get it to display properly.

Biff