Thanks for your help.
Unfortunately, find and replace will not search for a blank space and replace it with a dash "-". Some of the characters in the PIN field from the spread sheet such as "?", and "!" need to be removed as well, but I can't seem to get the find and replace function to do...