The issue has been resolved. If it happens again, please let me know.
What is actually in your post is as follows. The lines break at each [LEFT] or [/LEFT] tagMay I ask why the "line breaks" in the following post occur?
https://www.mrexcel.com/forum/excel...w-text-if-formula-result-0-a.html#post5005352
What is actually in your post is as follows. The lines break at each [LEFT] or [/LEFT] tag
=IF(ISNUMBER(1/MAX($N8:$Q8)),INDEX($N$7:$Q$7,MATCH(MAX([LEFT][COLOR=#222222][FONT=Verdana]$N8:$Q8[/FONT][/COLOR][/LEFT]),[LEFT][COLOR=#222222][FONT=Verdana]$N8:$Q8[/FONT][/COLOR][/LEFT],0)),"NIL FOUND")
I'm not sure how putting it differently changes anything. You asked why there were line breaks in the post & I answered that the best I could. How/why those 'LEFT' tags got into your post I don't know, but they are there.Let me put it differently:
The way the post looks is not what I intended. It happens under:Enhanced Interface - Full WYSIWYG Editing, while such was not the case before.
I'm not sure how putting it differently changes anything. You asked why there were line breaks in the post & I answered that the best I could. How/why those 'LEFT' tags got into your post I don't know, but they are there.
This post of yours, for example, has [COLOR] and (bold) tags, but notags & hence no line breaks.