Use compass directions in two columns to get data in a third

ShaneMellard 

Here's a formula that works on the basis of the assumption that you always have the North/South orientation in column B, the East/West in Column D. 

=IF(A28="","",(IF(RIGHT(B28,3)="rth","S","N")&IF(RIGHT(D28,4)="East","W","E")))

The outer most IF condition just keeps column F blank if column A is blank.

Beyond that, since "North" and "South" have three distinctive characters as their last three, it's easiest to just look for "rth" or "uth"--again, assuming you always have North or South in that column, and if it finds it's the North, then it reverses to "S"

and concatenates that with a similar IF condition that returns "W" if the word is "East" and vice-versa.

P.S. You appear to have formatted all those cells as "Text" which initially made it hard to enter a formula there. Unless there's some compelling reason to do that, don't. Keep them "General" until forced to change, and then do it cell by cell, or row by row or column by column as needed.