Remove Carriage returns or line returns from an excel cell

Written by PromoMagic on . Posted in Code and Formulas

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) , " " )


SSL Secured
|
Copy Right PromoMagic
|
+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 -