Used to be a \n in the search and replace dialog Replace field would insert a carriage return… now it just inserts \n litterally… Suggestions?
Tick the box labelled Regular expressions
Yeah, since I was using regex in my search it is ticked… no joy.
Carriage returns in cells can cause problems, e.g. if using Find and Replace it won’t search beyond the carriage return