Text Functions

C: =PROPER(CONCAT(__, ", ", __))

D: =CONCAT(__,__, "@abc.com")

E: =CONCAT(LEFT(__,1), ___, "@abc.com")

F: =CONCAT( UPPER(__), ", ", PROPER(__))

****

=VALUE( SUBSTITUTE( PROPER(__), "___", ""))

=CONCAT("____________", RIGHT(__,4))


​

Logical Functions

I: =IF(__>__, "______", "For Coaching")

J: =IF(AVERAGE(__,__)>90, "___", "__")