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/05