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.