Copy content of several columns into a single cell and change format on separate lines

Hello,

I'm having problems changing format on indivual lines within a cell. I need a macro that copies content from 3 columns into a single cell and then changes to format on the first line to bold, the second to standard formating and the third line to italic.

The lines in the target cells are of varying lenght, so I haven't been able to use Lenght() appropriatly.

The sheet looks like this, and contains somewhere around 1400 rows.
A B C
1 Text 1 Text 2 Text 3
2 ... .. ...
3
.
.

And I'm trying to get it to look like
D
Text 1
1 Text 2
Text 3
.
.

Any ideas? Help would be much apprechiated.

Try this:-

Please Login or Register  to view this content.

Regards Mick

Wow, that sure did the trick. Thanks alot!

Your welcome
Regards Mick