username length?

mallyg27

I'm importing usernames to active directory through excel. My question is, I have 800 users. I want the username to be first letter of the first name and first five letters of the last name. A lot of my users have long last names. Do I have to actually manually delete the last few letters off there names or is there a easier way to do this?

dynamik

Found this quick and appears to do what you want.

Dim rng as Range, cell as Range
With Activesheet
set rng = Intersect(.usedRange,.columns(5)).Cells
End With
for each cell in rng
cell = Left(cell.Text,5)
Next