Hello,

I have a list of IDs containing 32 characters and I need to format them in a certain way, namely to add dashes “-“ after the 8th, 12th, 16th, and 20th characters. So my question is: is there any way to format like this en masse because I obviously can’t add the dashes manually for the thousands of IDs I have.

Here’s an example:
Current ID -> 0DA88BE61C864A99BE730EEE81D82FCC
Needed ID -> 0DA88BE6-1C86-4A99-BE73-0EEE81D82FCC

I’d appreciate any help for this.

Thanks,


Tom