Tips n Tricks for Microsoft Excel

 

To remove any content or empty place from a column in Excel file.

=TRIM(CLEAN(SUBSTITUTE(,CHAR(160)," ")))

e.g.: =TRIM(CLEAN(SUBSTITUTE(A1,CHAR(160)," ")))

Create conditional formulas

 The IF function uses the following arguments.

 

Formula with the IF function:

 logical_test: The condition that you want to check.

 value_if_true: The value to return if the condition is true.

 value_if_false: The value to return if the condition is false.

for reference you can use Microsoft