New Excel Field HOWTO - [WP]

  • Thread starter Thread starter WILDPACKET
  • Start date Start date
W

WILDPACKET

Have a xls file with 400 users in it with the following fields:
Employee Number, First Name, Last Name.

I want to add another field which shows me LastName and first intial of the
user.

e.g: If user name is John Doe the new field should automatically create
DoeJ.

How can I make this usign excel. I have 400 users with first name and last
name in seperate fields.

Advise Please.

Thank you
 
sub trythis()
for each c in range("c2:c400")
c.offset(,1).value=c & "," & left(c.offset,-1),1)
next c
end sub
 
With first name in Column B, and last name in Column C, try this:

=C2&LEFT(B2)

And copy down as needed.
 
Back
Top