Hello! i wonder if this is possible... and I hope it is!
I get the value for my import: 089300 (or any 6 digits). This in the database is the sort code with the format: 08-93-00. I could remove it from the replace excel that I paste for the dictionary and that would work (it replaces with the bank name).
However, it'd enter the sort code wrong. So I need to add an hyphen to it when inputting on the sort code... 2 characters and then 4 should have a hyphen added....
Something like: 000000 would become 00-00-00. There are thousands of possible combinations so it'd need to be done automatically - probably with regex?
It worked perfectly! Thank you so much :-)
I included a couple of lines to add leading zeros just in case Excel stripped them off from the beginning (better safe than sorry).