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.
14 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
I have knowledge in email & excel and macro. I will try to complete this task as per your requirement. Relevant Skills and Experience Excel macro and vb