Poll

Aboot this blog

This blog is a cross between a scrapbook and a diary. I hope you find something here of interest. If you’d like to keep up with things as I see them then you can subscribe to my news feed by clicking the icon below:

feed-icon-28x28.png

DISCLAIMER

Please note that any reviews/recommendations are based solely on my own experience and does not constitute a guarantee that you will have the same experience. Please do your own research before parting with any money - the risk is all yours!

The Briticiser

Looking for my world famous US to GB English spelling converter?

THE “BRITICIZSER”

www.us2uk.eu

IT’S HERE

Tags

  Odds and Sods     Software     Word     Bits and Bobs     Bookmarks     PHP     Flatpress     3D Stuff     Hardware     VBA     Acrobat     Excel     Plausible Lies     Reviews     Equipment     Family     News     Utilities     Windows     Browsers     Overcoming Disabilities         Education     Tutorials  

Find me on Facebook

facebook-icon-28x28.pngVisit my Briticiser Facebook Page to keep up with things here - lots of reviews of stuff I’ve really used and also all kinds of helpful computer tips with a heavy bias towards SAVING YOU TIME.

Find and Replace Line Breaks in Excel

Permalink: http://paul.us2uk.eu/?x=entry:entry160812-105344

One of the most frequent things I forget how to do is the replacement of line breaks in Excel cells. You can put a line break in an Excel cell simply by pressing Alt+Enter while you are typing in your data, but sometimes you want to replace some of the text PLUS the line break.

To do this is equally simple (once you know how) just by entering Ctrl+J so say you have a cell with the following data with a line break in it:

ABC
XYZ

and you want to either replace or even remove the top or bottom line you would go to your Find & Replace dialogue box (press Ctrl+H) to bring this up and then enter either of the following in the “Find what:” box…

To remove the top line type “ABC” then press Ctrl+J (it will not actually show anything because the Find what box is only one line high, and you might just be able to make out the top of the insertion point I-bar cursor flashing below the A), then type in whatever you want in the “Replace with:” box - or just leave it blank if you want to delete that top line.

To remove the bottom line first press Ctrl+J THEN type “XYZ”. In this case you might not see anything when you type the “XYZ” except (again) the flashing top of the cursor moving along as you type the letters on what a line which is hidden by the restricted height of the “Find what:” box.

Thanks to Debra Dalgleish for this excellent tip ever at her equally excellent Contextures Blog…

http://blog.contextures.com/archives/2013/05/28/find-and-replace-line-breaks-in-excel/

Support our caregiving

If you found anything on this site of use, interesting, or even mildly amusing then please consider dropping a few pennies in the jar to help us to take care of our disabled son who contracted encephalitis in 2007 at the age of 6 and who is now confined to a wheelchair. He is getting bigger as his mother and I get older, imagine that, please. Every penny we collect goes towards his upkeep, and towards his future care requirements.

Thank you.

Support our caregiving

Support our caregiving

If you found anything on this site of use, interesting, or even mildly amusing then please consider dropping a few pennies in the jar to help us to take care of our disabled son who contracted encephalitis in 2007 at the age of 6 and who is now confined to a wheelchair. He is getting bigger as his mother and I get older, imagine that, please. Every penny we collect goes towards his upkeep, and towards his future care requirements.

Thank you.