Excel: a little odd: Need to convert TODAY() date to two digits 0000 and use 2 letters + 6 random number formula

Hello, I'm breaking my head here, I understand a little =Tex which changes my TODAY() cell in another cell to 0406. Now I would like to add initials at the front like CS0406 followed by 6 random numbers. CS0406123456- It's killing me, can someone help? It doesn't have to pull the date from the =TODAY() cell, if there's a formula that can do all of the above, that would rock. Can someone please guide me as I get stuck using TEXT/RANDOM etc. Been searching for hours. Chris.

This question generated 10 answers. To proceed to the answers, click here.

This thread is current as of April 06, 2018.

For more resources for Microsoft Excel