How to format a string as an GUID in Excel

Yesterday i had to format at string in Excel to get it displayed as a GUID.
It seems like Excel does not support this by default.

And google was not my freind in this case.

So i had to come up with a custom soulution, that i just wanted to write down for you to use.
It might not be a bullet proof solution, but it worked for me :-)

The formular i created was :
=MID(B2;1;8)&"-"&MID(B2;9;4)&"-"&MID(B2;13;4)&"-"&MID(B2;17;4)&"-"&MID(B2;21;128)

My inital values in Excel was something like this : 199b07b1e0ed4824a42ffbfa51e94dd6 (a Guid without the dashes).

The above formular will output the following : 199b07b1-e0ed-4824-a42f-fbfa51e94dd

If you need to copy the GUID formatted results somewhere, then you have to copy the Formala rows like shown on the screenshots and paste the Values to another column.

Please be sure to edit the formular so it will get the initial values from the right column. In my example the raw values was in column B.


Best Regards
Lasse Rasch