I have a spreadsheet containing rows of addresses including a field for County.

The County field is blank for any address where the Post Town has same name as the County ie Armagh, Londonderry, Antrim etc.

How can I prefix the name of the County in each cell with either "Co. " or "County " but only do it in the cells that have an entry ie leave the blank ones blank ?