PRACTICE

FUNCTION TO LEARN DATA

PROPER

FORMULAS

LEFT RIGHT

MID

CONCAT

CONCAT

TEXT

C$3$ and CA

Cant CA C$3$ and C$4$

it adding leading zero within an emal:

TEXT SEARCH

shutchinson@nowhere

Hint search for symise LEFT

thichinsong nowhere

and SEARCH

Putting if all together

Thy to use the fun being asiat in

column

There may be more than one way to complete

complete a function, you will notice

Lise trial and error at first. Build complex tom

First Name

Short Name $($First Li New Zp