How do I split a text-code like 2VBG45 or CF34HJ into 2-VBG-45 and CF-34-HJ
What I want to achieve is insert a dash at the place where the text changes from letters to numbers and were it changes from numbers to letters.
The by our customer delivered text-code is always 6 digits but the place/amount of numbers and letters are not always the same. So the total of numbers and letters is always 6 but the amount of letters and numbers in each code can be 2-4 3-3 and 4-2 so there ale always 2 dashes to insert.
Any help will much be appreciated.