Hi all,
I have a csv file with 2300 entries in it that are lists of addresses.
However, like most addresses they vary in the amount of information they have.
I need to select a column, for instance, column E, then if it has "England" in the cell I need to insert a blank cell and shift them right.
Anyone know how to do this in bulk instead of manually?
I have a csv file with 2300 entries in it that are lists of addresses.
However, like most addresses they vary in the amount of information they have.
I need to select a column, for instance, column E, then if it has "England" in the cell I need to insert a blank cell and shift them right.
Anyone know how to do this in bulk instead of manually?