Excel TRIM Formula

 TRIM Formula  

This formula is used to remove unnecessary space in a cell or Text.

Example

=TRIM(A1)

Cell A1 has unnecessary space between Ram__Kumar __Gupta, so it removes unnecessary space and give RESULT = Ram_Kumar_Gupta.