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.
Ah. I just realised it refers to Calc. \n doesn’t work in Calc in Replace field, see wiki
Carriage returns in cells can cause problems, e.g. if using Find and Replace it won’t search beyond the carriage return