Trim all?


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?





0 Replies