I am trying to figure out how to extract and combine into a new column the first 3 letters of one column, if only 2 characters add a z as the 3rd letter), and the first letter of another column. Using the LEN and LEFT functions only.

I cannot find a reference to this in any of my textbooks. I don't only need the function but would like to somewhat understand it too.

Any help would be appreciated.