Is there a trim all?
I need to keep my raw data as is. Next tab is simply a table linked to each raw value: +sheet1!A2. I used: +trim(sheet!A2) and it auto-filled. However, I still have to drag to the end-right.
Should I look into using +Code() and/or +char() to automate?
