I have given John off-list an Excel routine that will do this and he tells me that it works perfectly. I can supply to any other co-ordinator who wants it. Jeff ----- Original Message ----- From: "John Mellors" <[email protected]> >I am currently checking deaths for 1872 and the end of every name > field has a full stop. Does anyone have a simple routine to amend the > file to go from > > SURNAME,Name,Age,District,Volume,Page > to > SURNAME,Name.,Age,District,Volume,Page > > Is there a quick way to do this in EXCEL - as far as I am aware the > only exception to the requirement is if the Name already ends in a > full > stop then nothing is to be changed > > MELLORS,John,99,Nottingham,7b,123 > would become > MELLORS,John.,99,Nottingham,7b,123 > > MELLORS,John E.,99,Nottingham,7b,123 > would not change > > Regards > John M > (joint co-ord for the John Pain syndicate) > > -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.7.4 - Release Date: 25/01/2005