Does anyone know how to delete empty lines within a cell?
for example I have this:
The Americana Series embodies a rustic, country farmhouse look that exudes the style, grace, and quality craftsmanship of a bygone era. Americana faucets are offered in a wide selection of finishes and fit perfectly with both traditional and eclectic modern décor.<ul>
<il>Two Handle Kitchen Widespread Faucet<li>
<il>Metal Lever Handles<li>
<il>Spout Swivel 360⁰<li>
<il>8-5/8" Reach, 6-3/16" from Deck to Aerator<li>
<il>Ceramic Disc Cartridges<li>
<il>3-Hole 6" to 16" Installation<li>
<il>With 1.5 GPM Flow Rate<li>
____
I am trying to remove those blank spaces. Is there a code or formula to remove all blank line spaces and make it look like this?
The Americana Series embodies a rustic, country farmhouse look that exudes the style, grace, and quality craftsmanship of a bygone era. Americana faucets are offered in a wide selection of finishes and fit perfectly with both traditional and eclectic modern décor.<ul>
<il>Two Handle Kitchen Widespread Faucet<li>
<il>Metal Lever Handles<li>
<il>Spout Swivel 360⁰<li>
<il>8-5/8" Reach, 6-3/16" from Deck to Aerator<li>
<il>Ceramic Disc Cartridges<li>
<il>3-Hole 6" to 16" Installation<li>
<il>With 1.5 GPM Flow Rate<li>
I have a spreadsheet filled with them. Need help quick! Thanks!
Bookmarks