Hi All

If I may offer.

Why not add an extra column and have that column record the street via
Data Validation where the street/road format is predefined so that users
can only select from that list.

This would then eliminate the need for complicated VB coding and the
potential Saint / Street conflict issue.

You could then, if you choose to, use vba to update the address value to
include Address&" "&Street.

Or

A UserForm for entering required details ( still using a Combo/List
Box/DataValidation for street selection that updates the underlying cells.

HTH
Mick.