Description:
The CLEAN function uses to remove the unwanted characters from the relevant cell. This will help you clean the data to get perfect value.
Formula Syntax:
Example:
Important points:
You have to clean unwanted texts from respective cells, otherwise Other formula's like VLOOKUP will not give correct results.
Working file
Comments