Hi Sir,
Thanks for looking on my post & Sorry for making you confused because of my poor explaination,

Actually i am using a Application, where i need to trigger these splitted addresses from excel to that application screen,
Here as you said for Address (10205 134 AVE NW) , i know that NW(Northwest) is direction, but as per our rule it should not be in C column,
C column should contain only (N,E,S,W).

NoW Existing script considering like...if second word or last word of addresses contains any single character its putting it in C column,
but now i need like...it should consider only the letters (N,E,S,W).....Rest all should be not be considered in C column.

if i am not clear please let me know, i will send screenshots of that Application, which i am using.

Thanks in Advance.