Chuck

Try one of these approaches:

="<br clear="&""""&"all"&""""&" "&A2&"<table width=100%"

or

="<br clear="&CHAR(34)&"all"&CHAR(34)&" "&A2&"<table width=100%"

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=536825