New Excel Field HOWTO

New Excel Field HOWTO - [WP]

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

WILDPACKET - 23 Nov 2007 17:32 GMT

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

Reply to this Message

Don Guillett - 23 Nov 2007 17:39 GMT

sub trythis()
for each c in range("c2:c400")
c.offset(,1).value=c & "," & left(c.offset,-1),1)
next c
end sub

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

>
> Have a xls file with 400 users in it with the following fields:
[quoted text clipped - 14 lines]
>
> Thank you

Reply to this Message

RAGdyer - 23 Nov 2007 21:36 GMT

With first name in Column B, and last name in Column C, try this:

=C2&LEFT(B2)

And copy down as needed.

Signature

HTH,

RD

----------------------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
----------------------------------------------------------------------------------------

> Have a xls file with 400 users in it with the following fields:
> Employee Number, First Name, Last Name.
[quoted text clipped - 13 lines]
>
> Thank you

Reply to this Message