Hey guys,

Does anyone who how I can copy Trimmed text (TRIM function) into another spreadsheet and have the resulting trimmed text copied to the cell, rather than seeing the error #REF! ?

many thanks,