Assume this data is in cols A & B, from row1 down:

john doe
joe doe
mary jane
peter doe
etc

Put in C1:

=IF(OR(A1="",B1=""),"",LEFT(A1,1)&B1&IF(COUNTIF($B $1:B1,B1)-1=0,"",COUNTIF($
B$1:B1,B1)-1))

Copy C1 down

Col C will yield:

jdoe
jdoe1
mjane
pdoe2

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"CCloud" wrote in message
...
I am attempting to make unique user Id's using excel or access.
I want to CONCATENATE a first name and last name into first initial last
name but if there are duplicates I want the second one to be first initial
last name 1.

ie: john doe jdoe
joe doe jdoe1
Help!
Thanks