Many thanks. Was not as easy as I thought but have managed to stumble my way through and managed to get it to work. Have recorded it in my "Notes"...

Yes, one number between 5 and 9 digits. Sorry if I did not explain properly. New at this stuff.

Many thanks 'happygeek'. This seems to work. Just have to sit down and work through the logic as a learning exercise.

:-P:-P:-P:-P:-P

I have a table of data with lines of various lengths. An example is

A Smith - Give #12345# Sydney City

B Jones and S Jones - Give #876543# Washington

I am...