Mary,
A suggestion if you want help. STAY in your original thread.
And, Us Texans don't know what a "postcode" is. Is that like a zipcode? If
so, in the US that is a 9 digit+4 number.

--
Don Guillett
SalesAid Software

"Mary" wrote in message
...
Hi - I have explained this a bit better now -

If I have a cell and the contents are like this
here are 3 examples -

GREENGATES S.P, APPERLEY RD, GREENGATES, BRADFORD, BD10
0PU

SILSDEN, CRINGLES, SILSDEN, KEIGHLEY, BD20

MIDDLESMOOR SERVICE RES, MIDDLESMOOR SERVICE RES,
HARROGATE, NORTH YORKSHIRE, , HG3

How can I get the postcodes out of those cells? for now I
just want them to go into the same row in the end column.

any tutorials or similar or pages with similar stuff on
would be great. Thanks

Mary