Text String

G

Garry Fitzgerald

Hi all

Is there a way to find and strip out postcodes that appear in many fields.

I want to end up with address fields and a postcode only field

postcodes such as CF10 XXX or CF4 XXX

many thanks
 
M

[MVP] S.Clark

String functions such as Left(), Right(), Mid(), InStr(), and Len() can
assist you with this kind of manipulation.
 
Top