Hi All,

Is there anyway to detect specific text from a sentence in excel. for example I have addresses in col A and I want only the post code to be display in Col B.

See below for an example.

A B
15 Galowgate Edinburgh EH12 5DL EH12 5DL
25 London Road Glasgow G5 3PL G5 3PL