Also, as far as initials being returned when names are entered, I found this function online: =if(len(B3)-len(SUBSTITUTE(B3," ",""))=0,left(B3,1),if(len(B3)-len(SUBSTITUTE(B3," ",""))=1,left(B3,1)&mid(B3,find(" ",B3)+1,1),left(B3,1)&mid(B3,find(" ",B3)+1,1)&mid(B3,find(" ",B3,find(" ",B3)+1)+1,1))

I don’t want it to be in the cells, I would prefer it to be a part of a dynamic range; but every time I try to apply it, something happens that results in an error. I conjecture hat it wouldn’t work, or I’m missing something.