![]() However, there is a limit to the number of characters the header or footer will accommodate. You could perhaps use SUBSTITUTE to replace NL with % or something like that. See the message “We could not find anything to replace” and “FYI: It’s Possible the data you are trying to replace is in a protected sheet. ![]() This keyboard shortcut works the same way on Windows and the Office 2016 for Mac. In a cell or in the formula bar, place the cursor before the argument that you want to move to a new line and press Ctrl + Alt. Therefore, a new line can be inserted into a cell using the function: CHAR( 10 ) Add new line to concat(…) expression. The line break character is represented by character number 10. When working with Excel formulas you can insert a new line into an Excel cell using the Excel Char function. To me this is more intuitive, besides the fact that it took me a while to discover that Alt+Enter in excel is the same as Shift+Enter in PQ. Thank you! In the end, hit enter to break the line. Figure 1: How to add a line break … Replacing all line breaks on the sheet with spaces.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |