Thursday, 12 November 2015

Using excel data cleaning functions CLEAN () TRIM () & PROPER()

Scenario - cell A1 contains text in   Camel case "EXamPlE TEXT " with some extra spaces and non printable characters

Use  combination of data cleaning functions in cell A2   =CLEAN(TRIM(PROPER(A1)))

You will get desired output as "Example Text".

Please note specially in case of Postal code/Zip Code use UPPER function by replacing PROPER as generally they are required in upper case.    


No comments:

Post a Comment