How to change the metadata of a file like author in Excel
To do it in Excel, here is the answer:
a) Click on "Info" under "File". Under "Properties", click on "Advanced Properties".
b) Change the meta-data of the file as required.
c) All the numbers in the range selected would be prefixed appropriately (in this case the numbers would be prefixed with "NC-").