automatic spacing between 4 characters

[frostiak]

Hello everyone,

I need help in an online worksheet that I share with colleagues. We need to write down codes of 16 characters, all spaced between every 4 characters (e.g. a111 1a1a 1111 aa1a). It would be amazing if I could just put down 16 characters, and it spaces each 4 automatically for me. I can do this with just numbers or just letters, but not with the combination of both which I do need. Could anyone help me with this? Thank you so much in advance.

Kind regards,
frostiak

 

[johnnyL]

Assuming your 16 character string is in A1, you could use the following in perhaps B1 for example:

=LEFT(A1,4) & " " & MID(A1,5,4) & " " & MID(A1,9,4) & " " & MID(A1,13,4)

You could then drag that formula down the column.

 

[Rick Rothstein]

Here is another formula that you can also consider...

=REPLACE(REPLACE(REPLACE(A1,13,0," "),9,0," "),5,0," ")

 

[frostiak]

Hey guys, thank you so much for the solutions! Much appreciated. Have a nice day!