![]() ![]() ![]() Now you shouldn't have any more line breaks in your text.:) (On a side note, you don't need to replace with a space you can replace it with another symbol if that may be more convenient for what you're doing in Excel.). Now hit command + c to copy this invisible character, and then got to Edit > Find > Find and Replace.Īnd search for your copied character and replace it everywhere with just a space. This will select the invisible new line character. Here's a simple, non-Excel way to get rid of all the line breaks in your text: Paste the data into TextEdit, put your cursor at the end of any line, then hold shift and press the right arrow once. A Convergence of Offices - Office for Mac 2011 & Office 2010 for Windows. ![]() From the box that opens up, go to the “Line and Page Breaks” tab. To do this on the Mac, go to Word Preferences > View. Here's how you can remove those pesky section or page breaks that aren't immediately obvious. do not fit page size', and then excel auto inserted a bunch of page breaks > (basically on almost every single column, every few rows) that I can't seem > to remove (b/c they're not inserted - dotted lines in page break view). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |