Hi,

I have been kindly sent a large amount of data in an excel spreadsheet, which I need to import into another database. Unfortunately someone has inputted n/a in everyone cell that data is either missing or not required.

Can anyone suggest an easy way to delete all the n/a's from the cells to leave them blank, rather than me, deleting them manually.

Any help much appreciated.

G