Live Office single quote

Good day,

If I pull webi content into excel using live office, all my text values are prefaced by an apostrophe and a new line - Char(10).

If I base an xcelsius dashboard on this data, values display the extra empty line.

How do I get rid of the extra line? Char() and Clean() are unsupported functions in xcelsius.

Leandi