Hi Ron,

I will try and use your code tomorrow. I suppose I better close this query
now (wether or not I can make it work!)
Again thank you for your help
CAT

"Ron Rosenfeld" wrote:

On Wed, 10 Dec 2008 14:40:04 -0800, CAT wrote:

Hi Ron,
Thank you. I have never used VBA (although I have a book about it); I will
try and follow your instructions in a new book: copy and paste my downloaded
lists in it and see what happens. Just in case I do it all wrong, how can I
get rid of a VBA Code and start again? I know it's not as simple as clearing
a formula from a worksheet.

Thank you again
CAT


CAT,

Looking at the examples you posted to Mike H, you will need to change the
function I posted to:

=RegexSub(D1,"\s+(Address|Telephone|Tel Nr)[\s\S]+","")

--ron