combine multiple cells into new cell maintaining font format

Hello,
I have a worksheet with bibliography information of both books and thesis.
i.e.:
For Books: column A: the author and year, column B: book title (in Italics) , column C: editor
For Thesis: column A: the author and year, column B: book title (in Italics) , column C: academic grade, column D: editor

What I would like to do is to combine all this information (keeping the italics) in Column F.

I've found a macro code on this thread:
http://www.excelforum.com/excel-general/561722-combine-two-cells-into-new-cell-with-different-font-format.html
and by hit and miss and some google digging I was able to make the information appear on row F although, it still only combines only the information of rows A and B.

Here's my macro so far:

Please Login or Register  to view this content.

If someone could help me I would be very grateful.
Thank you in advance.

Hi venturu,

. You explained your problem quite well, but it makes it a lot easier for someone seeing your problem for the first time if you prepare a clear “Before” and “After” “Picture”

. To do that you can either
. 1) - post two screenshots ( see notes for how to do that in my signature – The BB Code option is the relevant one in the downloaded Add-In. ) Please do not post am image as we cannot copy that to a spreadsheet!)
. or
. 2) - Up left in the Thread editor is a Table icon. Click that, create an appropriately sized table and fill it in. (To get the table icon up in the Reply window you may need to click on the “Go Advanced” Button next to the Reply Button)

.3 ) – attach two files. ( or one File with two sheets, - a “Before” and an “After” ) (To get the paperclip icon up in the Reply window you may need to click on the “Go Advanced” Button next to the Reply Button)


………..
. Make sure there is just enough data to make it clear what is needed, so reduce to a maximum of about 40 rows. Remember to desensitize the data – make the data up if you like, as long as it is representative of all possible scenarios and data types.
. - So the “Before” should have just your initial data.
. - The “After”, hand written by you should show exactly how it should look as a result of a Formula or after running any VBA macro based on the exact sample data you give in the BEFORE.


Alan