Hello windcloud2,

This can be done with a formula in a column next to the original cell.

=RIGHT(A1,LEN(A1)-SEARCH("West",A1)-4)

Thanks,

Rvasquez