The following function is for generating 8 digit unique number in excel and masked with 123:
=RANDBETWEEN(12300000,12399999)
The following function is for generating 8 digit unique number in excel and masked with 123:
=RANDBETWEEN(12300000,12399999)
=TEXTAFTER( A2 , "@") or, =MID(A1, FIND("@", A1) + 1, LEN(A1) - FIND("@", A1))