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.
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