AnsweredAssumed Answered

Field Calculate Need Last Word of String

Question asked by cindylewis on Aug 17, 2016
Latest reply on Aug 19, 2016 by Dan_Patterson

I am working with street names and need only the suffix returned (Dr, Blvd, St, Pkwy)

ei. Mountain View Blvd      = Blvd

I attempted to go from the right to left and looking for the first space " " from the right (between View _ Blvd) to split?

in VBA if possible

Thanks

Outcomes