VBA programming

Closed - This job posting has been filled and work has been completed.

Job Description

Hi all,

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

Open Attachment