I have 2000 fields in a column, with garbled text in them apart from an email address in each which I want to extract, in each case the e-mail address is surrounded by< > how would I extract the address only to another field
ie in A1
fjdhflkjsjdhjaldhskj<myemail@blahblah.co.uk>hbjiduegduqhuhwd
i wantin A2 myemail@blahblah.co.uk
any help would be appreciated
This message was edited by steven H on 2002-03-27 10:04
ie in A1
fjdhflkjsjdhjaldhskj<myemail@blahblah.co.uk>hbjiduegduqhuhwd
i wantin A2 myemail@blahblah.co.uk
any help would be appreciated
This message was edited by steven H on 2002-03-27 10:04