Access VBA Module

Module required to split UK postcode (zip codes) as per attached spreadsheet. The table on left is an Access table. The yellow table on right will be the resulting query, The module needs to b run to create a query as per the yellow table. So the new row is created after each space and then at the end of the cell. Unless there is a space the group will remain together e.g. BD1-22,97-99 1 B, BB, BD1-22,97-99, BL, CH, CV, CW, DE, DN1-12,16-17,21-22,31-35,40-41,55, DY, EN6-8, GL1-4,7,14,16-20,50-56, HD, HR1,4,6-9, HX, L, LE, LN1,5-6, LS, LU, M, MK, NG, NN, OL, PE1-11,13-16,19,26-30,38,99, PR, S,SK, SN1-7,25-26, ST, SY1-4,99, TF, WA, WF, WN, The project needs to be uploaded in Access.