Trim all?

Contributor

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