Joining names; extracting codes or converting dates is usually done with formulas, but there is now a formula-free solution called Flash Fill.

See how you can do four transformations in less than a minute.