Column A is populated with codes that have a certain format. I need to split this format into two columns.
A code looks as following:
5, 6, or a 7 digit number and then a description. So I need to have these digit numbers in column B and a description in column C.
(example 84100 PHOSPHORUS)