Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.