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

I have heaps of white space in my excel data. I tried the Trim Function but no good... can anyone help? Thanks

(Modified) Example here below..... "

    <li>Elastic Sizing Band with 5 - 6cm Brim</li>
    <li>3 Sizes
    - (#4131 54cm to 50cm:::#4132 50cm-46cm:::#4133 58cm-54cm)</li>
    <li>Rear Toggle Adjustment</li>
    <li>Popular choice for schools and kindergartens </li>

share|improve this question

Try something along the lines of:


to remove line breaks from the text in cell A1. CHAR(10) represents the line break.

Or to convert line breaks to spaces, you can use:


The TRIM function in this case helps to reduce multiple line breaks to a single space.

share|improve this answer
Thanks... I tried that way but got stuck...I ended up using the Clean function, then the Trim function. It all seemed to be ok now.Thank you for your response – David Jan 24 '12 at 5:25

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.