Removing whitespace when writing to excel

#1

Hi Everyone

Im brand new to this so any help would be appreciated. When I write my variables to excel all work fine however one category has a number of "white spaces’ that precede the extracted text.

Anyone have any solutions for this?

Thanks a million

#2

Hi @DSavill,

You could try to use Trim method before writing in excel file. LTrim(String) should cut off all the white space that precede the text.

Hope this helps;