Excel → T-SQL › TRIM
Excel TRIM to TRIM / LTRIM RTRIM
Excel TRIM also collapses internal double spaces. SQL TRIM only hits the ends.
LTRIM(RTRIM(email))
-- also squash double spaces
REPLACE(LTRIM(RTRIM(email)), ' ', ' ')Run REPLACE twice if the sheet had triple spaces.
Canonical translation
LTRIM(RTRIM(email))
-- also squash double spaces
REPLACE(LTRIM(RTRIM(email)), ' ', ' ')Then write it on a ticket
Monday is free. A colleague asks, you type, we mark it.
Clock in free