User Logon Names

[admir]

Hi all,

I am making a spredsheet with my user logon names.
What I want to do is genarate a logon name field
automaticly.

For example:

User ID First Name Last name Logon Name
1 Yo Yoyo =First+1

You se what I want to do?

I want to generate a logon name from first name + User ID

How can this be done?

Please help.

Regards,

Admir

 

[M. lane]

Hi all,

I am making a spredsheet with my user logon names.
What I want to do is genarate a logon name field
automaticly.

For example:

Try this in cell D1 as shown below: =CONCATENATE(B1,A1)

User ID First Name Last name Logon Name
1 Yo Yoyo =CONCATENATE(B1,A1)

A1 B1 C1 D1