We recently upgraded to live version, 2016. In previous version 19 we were able to send reports with account codes to Excel without "indentations" and existing vertical lookup formulas worked well. ...
What are the formula's to remove the indentation? I am aware of =Trim(A1) etc. But is there another?