[joe2chillo]

Originally Posted by Farling

Hi Joe,

In the example you sent me, you have a cell with the formula:
=CONCATENATE("<b><i>",X2,"</b>. ","<i>",Y2,"</i>. ",Z2)

However, this results in the b and i not nested properly. Since there is an opening b then i, but you only close the b after the X2.

In html, the elements need to be nested properly:
good = <b><i>Hello</i></b>
bad = <b><i>Hello</b></i>

In your other example, are you putting in " around the new lines just to get them into excel? The " aren't needed for the tool (they are required in CSV file format, but not in excel cells).

Is there a version of the excel concatenate function which will copy the cell format as well as the cell text when merging cells and free text together?

Google suggests that the following will add line breaks as part of concatenating multiple fields:
=A2 & " " & B2 & CHAR(10) & C2 & CHAR(10) & D2 & ", " & E2 & " " & F2

I through that example together quick rather than sending you the longer file I had been working on. My nesting is correct in my other file. I actually changed to the CONCATENATE as a hope it would resolve the issue as I was using & to combine the text earlier. I had not tried char(10) however and will give that a shot. I was also thinking of trying the html break tag to see if that will work. I will keep at it. Thanks.