Text String

  • Thread starter Thread starter Garry Fitzgerald
  • Start date Start date
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
 
String functions such as Left(), Right(), Mid(), InStr(), and Len() can
assist you with this kind of manipulation.
 
Back
Top