Is there a formula I can use to create a dictionary for -
If a column in my file has either numbers or letters then to give it a 'Yes' for a preference and if the column is blank to give it a 'No'.
Thank you for you reply but unfortunately that didn't seem to work.
I basically have a column in my file which consists of different telephone numbers as well as blank cells.
So anyone who has given me a number in that column will need a YES (to contact them) and the blank fields will need a NO (to not contact them).
We'd need some more information to be able to help. Did you test the dictionary entries you set up to see if they worked with the data you are importing? What were the test results?