Thanks for your help. The Data Text funtion worked great!

A typical cell would contain (Sherry Holt) (Jan 7
96), Score = 1.000"

and some had < preceding the address and at the end with no spaces,
but that was easy to remove using the find and replace with nothing
function. Again, thanks, you've saved me loads of time!


--
H00tenanny
------------------------------------------------------------------------
H00tenanny's Profile: http://www.excelforum.com/member.php...o&userid=28287
View this thread: http://www.excelforum.com/showthread...hreadid=478528