Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When using the text to columns feature in Excel to split a single column into two columns, I find that the second column has leading whitespace trimmed. Is there any way to force Excel to leave this intact? I can get around this by instead using the LEFT() and RIGHT() worksheet functions to extract the left and right parts of the single column, but this is more time consuming when I have to do this repeatedly.

I'm using Excel 2010.

share|improve this question

In Excel, the Trim function returns a text value with the leading and trailing spaces removed. =trim(A1) will do exactly what you're speaking about for cell or cell range; I always trim my text to columns with a drag down and paste special - values

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.