• Formulas
  • Excel Tips & Tricks
  • Excel Charting
  • Tutorials
  • VBA
  • Book Store
  • More
    • Blog
    • Download Area
    • Excel Video Tutorials
Home » Find And Replace Line Breaks In Excel

Find And Replace Line Breaks In Excel

July 28, 2013 by Barbara

It is really easy to insert line breaks into Excel cells, all you need to do is hit ALT+ENTER where ever you want one. I know that I normally use them to make text easier to read in cells, longer pieces of text or bullet points for example.

remove line breaks excel

It is though, slightly harder to remove them if you need to.

Normally if you want to find and replace some text then you would just hit the CTRL+F shortcut to bring up Find and Replace dialog box.

 

remove line breaks 1 excel

 

 

 

 

 

 

 

 

But, if you enter ALT+Enter in Find What, nothing happens apart form your computer beeping at you- not allowed!.

So, instead of the ALT+Enter shortcut we need to enter CTRL+J, this is the shortcut to the line break which is character 10 in the ASCII control code. You can search for line breaks using this shortcut instead.

So if we want to find and place out line breaks with a space.

 

  • Select the cells you want to search
  • Hit CTRL+H. This will bring up the Find and Replace dialog box with the Replace Tab already active
  • In the Find What dialog box hit CTRL+J (it will appear blank- that is ok).
  • In the Replace With dialog box just hit the Space bar to enter a space
  • Hit Find Next or Replace All to find your cells with to find all of your cells with the line breaks
  • Click Replace or Replace All to replace the line breaks with space characters

Excel Expert Course

More Excel Tips

1. Calculate A Moving Average In Excel

2.Refresh All Your Pivot Tables With One Click

3. Create A Table of Contents

Filed Under: Excel Tips& Tricks, Tutorials Tagged With: Excel, Excel Tips

Comments

  1. Ankit says

    July 29, 2013 at 8:22 am

    Ctrl + J really works 🙂
    In past when I had to find line breaks, I used to come up with a macro but this new trick is just awesome.
    Thanks for sharing 🙂

    • Barbara says

      July 31, 2013 at 12:49 pm

      Ankit

      Good Stuff Glad You Like It

      Regards
      Barbara

Tags

Blog Cells Excel Excel Charting Excel Excel Tips Excel Formulas excel tip Excel Tip Category Excel Tips Excel Tips& Tricks excel tutorials Excel Videos Excel Video Tutorials formatting Formula formula friday Formulas macro Macro Mondays Macros Pivot Table Pivot Tables Power BI Power Query Tutorials vb VBA Worksheets

Recommended Excel Resources

Free Excel Dashboard Webinar

Copyright © 2021 · Enterprise Pro Theme on Genesis Framework · WordPress · Log in

Search:

Popular Pages

  • Home

More Info

Want FREE Excel Tips?

Click on my FREE eBook, its my bonus for joining thousands of others who receive my 3 xFREE Excel tips every month in my Excel Newsletter. Join Us!.

Need Answers To Excel Questions Like These?

*How Do I Create A Timestamp In Excel?
*I Want To Change The Width Of The bars On My Excel Chart
*How Can I Find Out The Length Of My Text in Excel? Click the link below to receive more Excel tips' and my Free Ebook

New To Excel? This Is A Great Place To Start!!

Learn Excel Dashboard Course Excel Basics
Scrollbars
Colour of Sheet Tabs
Conditional Formatting
Calculations Introduction

Excel Charting

Self Expanding Charts
One Click Charts
Create Quick Dynamic Charts
Easy Combination Charts

Video Tutorials-If You Like To Learn By Watching

Subscribe to YouTube to get notified of of new Excel videos.


Self Expanding Chart
Delete Obsolete Items From A Pivot Table-Excel 2007
What Are Pivot Tables- Create Your First One
Enable The DeveloperTab In Excel

Some Fun Stuff

Pivot Table Song

© howtoexcelatexcel.com. All rights reserved.
  • Privacy Policy