Hi,

I have a spreadsheet with relatively large product descriptions (up to 40
lines or so) that are formatted with line breaks. I need to replace the line
breaks with HTML code so they will display properly when uploaded to a
website.

To do this, I am trying to find/replace "ALT010" (line break) with <br.
This works for the shorter descriptions, but many are giving me a "formula
too long" error. How can I fix this?

If no fix using the find/replace function, I am open to suggestions on how
to get these formatted descriptions into an HTML format.

THANKS!