In Mac Excel, how can I replace with newline?
Ex:
Finds all
AAA BBB
and replace all with
AAA
BBB
Please any help would be highly appreciated.
macms office
In Mac Excel, how can I replace with newline?
Ex:
Finds all
AAA BBB
and replace all with
AAA
BBB
Please any help would be highly appreciated.
Best Answer
Manually Adding a Line Break
You can do this by pressing Option Enter at the point you want to insert the line break.
It's best that you format the cell(s) as Text to ensure the best results.
Mass Insert Line Break (a.k.a Search/Replace)
You can do this on a mass basis with Search & Replace. As before, it's important to format your cells as text. In the replace field, use the generic formula
concat
(concatenate) functionCHAR(10)
as the symbol fornewline
Using this methodology, you can "fix" multiple lines of text (like an address). See the animation below for an example: