How to split numbers from one cell to make it look like Mac address

Question

How to split the data from one cell to 8 rows in excel

For example: There is given long data in one cell: 65178492194051241284... The sorted values should look like:

65:17:84:92
40:51:24:12

Answer 1

Excel offers multiple options to help you build your own formula

LEFT is used to extract characters from the LEFT of the string (also MID might be useful in your case) https://www.excel-easy.com/examples/substring.html

Combining LEFT/MID with CONCATENATE you should be able to produce the expected output

https://edu.gcfglobal.org/en/excelformulas/using-concatenate-to-combine-names/1/

Something similar to

=CONCATENATE(LEFT(A1,2),':',MID(A1,2,2),':', MID(A1,4,2),.... )