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

In Excel, if I have two lines in A1:


but if I go over to A2 and type =lower(A1), I get:


How can I preserve the newline between Hello and World?

share|improve this question
up vote 4 down vote accepted

Use =lower(A1) and then turn on Wrap Text for that cell.

share|improve this answer
works great - thank you! – arturomp Apr 18 '13 at 20:40

Oddly enough, the newline is still there in A2, but the formatting of the cell is not showing it. If you click on A1, click Format Painter and the click on A2 then the newline will appear. You can also right click and select Format > Text

I don't think you can apply the right format as part of the formula though

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.