Line breaks in Excel

  • Thread starter Thread starter Fat Doris
  • Start date Start date
F

Fat Doris

I have been sent a spreadsheet where each address is entered in one cell and
the line breaks appear as <br>, which unfortunately appears when I attempt to
do a mailmerge using this data.

I know there is quite a simple way to replace this in Excel with a line
break, using find and replace, but I can't remember it. Can anyone help
please.

Thank you.
 
Hi,
to replace something you hit CTRL H, in your case go to , Page Layout,
breaks, remove breaks
 
Back
Top