Closed - This job posting has been filled and work has been completed.
we a VBA based template to clean Excel files (sample attached) as follows:
For column "ISBN:"
- delete dashes ("-")
- delete word "ISBN"
- delete spaces
- make sure at the end all are 13 digit -> if not 13-digit, ask for each line if line is OK
- in titles delete all line breaks (of any kind)
Finally, auto-save as comma delimited csv file