Hi Experts.
I have a BOB report with Macro in it, output as Excel. From couple of days one of the row in Excel is splitting into two. Please can you let me know what should I do to rectify this? I have attached the Excel out put, Line no 1128 is splitting into 1129 half way through.
Thank you very much for your time.
Rob_mot 
(BOB member since 2019-01-28)
If it’s breaking on a text field (I don’t see the attachment in your post), then it’s likely there’s some hidden line breaks or tab characters. You need to export modified text fields -
Text (mod) = replace(char(9),(replace(char(10),original text,"")),"")
(I think those are the correct char codes for tab and line break…)
Maddye (BOB member since 2009-01-09)
Thank you very much for your reply Maddye 
Rob_mot (BOB member since 2019-01-28)