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.

In Excel, if I have two lines in A1:

Hello
World

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

helloworld

How can I preserve the newline between Hello and World?

share|improve this question

2 Answers 2

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

 
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.