Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .