Remove Carriage returns or line returns from an excel cell

This formula removes all the carriage returns from a cell. We find a lot that suppliers tend to have extra formatting in their descriptions that can mess up your imports, this code will resolve that.

=SUBSTITUTE( A1, CHAR(10) , " " )

Copyright © 2020 PromoMagic Ltd | +44 (0)1795859639 | This email address is being protected from spambots. You need JavaScript enabled to view it.

Registered in England and Wales Company Number: 11970723 -