SetAppleScript'stext item delimiters to replaceStr
SetAppleScript'stext item delimiters to searchStr ToreplaceChars (theText, searchStr, replaceStr ) SetaCell's value to myreplaceChars (aCell's value as string, removeThis, replaceWith ) Tell theSelection to repeat with aCell in cells
Tell ( first table whose selection range's class is range) ' - type exactly one line break between the ''.
(Just copy-paste it into Script Editor and hit the triangle run button.) If the unwanted line breaks are in many different cells and you don't want to fiddle around with extra columns and formulas, then you can just select the cells in the range you want to clear of line breaks, and with the cells selected, run this script.
