Break Text into 6 groups

hi,

I need a macro to add a space between text in col C. Each text in col C is always 24 characters in length. I need to insert a space after each 4 character. The original text is in this format SA4810000035258281000105 and once I enter the data in column C, I need the target cell text to convert in this format SA48 1000 0035 2582 8100 0105

Thanks @maras_mak and @MarvinP for the solution. Actually I need a worksheet event code Target Column [C] and target cell text to convert to the desired format.

hi,

below is the code written by @Jindon to add space after every 4 digits. It works fine if there is only numbers but not alphabets. How I can amend the code to get the below result.

SA48 1000 0035 2582 8100 0105

Please Login or Register  to view this content.

try changing \d{4} to .{4}

Thanks @XLent and @Bo_Ry, Both the code is working great. Thanks to all who helped to solve this thread.