Clean extra spaces from imported names (TRIM)
A CRM export landed in your inbox, and every customer name carries stray spaces — leading, trailing, even doubles in the middle. Your mail merge will bounce on all of them. Fill the Cleaned name cells C2:C5 so each name from A2:A5 is trimmed to a single normal form.
Your solution should use cell references so it updates automatically when Test Case input values change.
Notes
TRIM removes leading and trailing spaces and collapses internal runs of spaces to a single space. It does not remove non-breaking spaces (CHAR(160)) from web data — SUBSTITUTE handles those.
FAQ
How do I remove extra spaces in Excel?
Use =TRIM(A2). It deletes leading and trailing spaces and reduces any run of inner spaces to a single space.
Why do some spaces survive TRIM?
TRIM only handles the standard space character. Non-breaking spaces (CHAR(160)) from web pages survive it — wrap the text in SUBSTITUTE(text, CHAR(160), " ") first.
Can I TRIM a whole column at once?
Write =TRIM(A2) in C2, then fill down (or double-click the fill handle) so every row gets a cleaned copy next to it.