Quote:
Originally Posted by Farling
Can you shrink down your source file to just the line or lines that are causing the problem?
Do the cells that you are joining together (e.g. AK4) have the "<" symbol to be displayed? This will cause problems with the HTML.
|
The cells I was combining had no tags but I figured it out. The HTML Tags are required but the </html> tag needs to go at the end. So I just looked to see if there was anything in the initial field again and if there is I put the close html tag, if not its blank. So the above example needs to look like this:
Code:
=IF(AI2<>"","<html><b><i>"&AI2&". </i></b>"&AJ2&IF(IL2<>"","
-"&IM2&"
-"&IN2&"
-"&IO2,"")&IF(BD2<>"","
"&BD2,"")&IF(LF2<>"","
-"&LG2&"
-"&LH2,"")&IF(IF2<>"","
"&IF2,"")&IF(AI2<>"","</html>",""),"")