Find and Replace

[copperberry]

I would like to do a Find and Replace on a special character (line break). I used to be able to go to Find and Replace, click on the More button and choose the character on which to search. However, now, in Excel 365, Version 1712 (Build 8827.2148 (Click-to-Run), the More button is gone! Is there a work-around for this?

[Zer0Cool]

I had to check for myself, no kidding it is gone. I am pretty sure you can still use the shortcode for it though but for the life of me cant find a list of them nor any mention as to why they removed this feature/button. Odd

EDIT: oddly enough Word in 365 still has this...maybe I confused Excel with Words feature for this. Ill have to check later an older version of Excel. The manual line break in word is represented by ^I which does NOT work in Excel find and replace when I tested it.

[copperberry]

Update: CTRL+J works to search for and/or replace a line break, but the More button is gone.