Working Hours :

Monday - Friday, 10am - 06pm

+911244962543

✅Formula: =PROPER(TRIM(A2)

✅Syntax: =PROPER(TRIM(Select the cell range)

✅Used TRIM function to remove unwanted space form the data.

✅Used PROPER function to change case into proper case from messy text format.