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

Please Login or Register  to view this content.

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