Is it possible to automatically format text from a string in Google Sheets?

[Aeruja]

I want to be able to automatically turn:

tct02110021

Into:

TCT-0211-0021

 

[Aeruja]

Found a similar question:

Format cells to automatically change MAC Address to 00:00:00:00:00:00 format

Hello, I am trying to set up a column to automatically change what ever is typed or pasted to be in a MAC Address format with the colons i.e. if typed or pasted 112233445566 it will show up as 11:22:33:44:55:66. I also want to copy the address and it be 11:22:33:44:55:66. I have tried using...

www.mrexcel.com

Will investigate