I would like to separate the numbers in the column "Article" and copy them into de column "Size". The cells without any number, I would like that in the "Size" column, appears a N/A.

Additionally, this information comes from a different book, so it has copied the original format and not just the information from the cell. So instead of having a column saying i.e.: "Blue canrdigans" the cell have the something like: "'Uniforms control'!U4".

This is an example of the table I wish to fix:

Table.jpg

Thank you very much for your help!