formula required to take first letter in 1 cells and add random number to create unique ID

Use this:
=left(a1,1)&left(c1,1)&d1

Originally Posted by minnesotaart

Use this:
=left(a1,1)&left(c1,1)&d1

Nope that didn't work for me, Thank you for the prompt reply though. See attached picture to see what happened.

To be honest it doesn't have to be a random number, it can add 1 count to each new patient. It does though need to be in the first name,last name, number ie.

SL123456
AJ123457
BB123458
DN123459
SR123460
ETC ETC

Originally Posted by popipipo

=LEFT(A2,1)&LEFT(C2,1)&TEXT(RAND()*1000000,"000000")

Maybe this will work

Oh yes, That worked perfectly. Thank you so very much.

"In my spreadsheet the first name is under Column 1, Last name Column 3 and the unique number generated in column 4."

I misread your original post. I thought you had already generated the numbers and they were in column 4. I interpreted that your question was how to put the 3 pieces together. My bad. Glad you got what you needed.

Originally Posted by minnesotaart

"In my spreadsheet the first name is under Column 1, Last name Column 3 and the unique number generated in column 4."

I misread your original post. I thought you had already generated the numbers and they were in column 4. I interpreted that your question was how to put the 3 pieces together. My bad. Glad you got what you needed.

Thank you very much for the help anyway.

I would suggest you use iteration since random numbers in excel by default don't account for uniqueness.

If you want a unique sequential number, then try this in D1:

=LEFT(A1)&LEFT(C1)&TEXT(ROWS($1:1),"000000")

then copy down.

Hope this helps.

Pete