Copy First Character of a cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kevin_jones01 - 17 May 2007 04:41 GMT

I am trying to copy the first character of a cell and combine it with another
row and place it in another row. I am trying to create usernames from two
columns First Name and Last Name. I am trying to use Concatenation is this
possible. How do I do this?

Example:

First Name Last Name Username

Jim Bob jbob
Sally Richards srichards

Reply to this Message

Fred Smith - 17 May 2007 05:06 GMT

Assuming your data is in columns a, b and c, the following will create the
Username for you:

=lower(left(a3,1)&b3)

Signature

Regards,
Fred

>I am trying to copy the first character of a cell and combine it with another
> row and place it in another row. I am trying to create usernames from two
[quoted text clipped - 7 lines]
> Jim Bob jbob
> Sally Richards srichards

Reply to this Message

Mike - 17 May 2007 05:08 GMT

try this

A1 B1 C1
Jim Bob =LEFT(A1,1)&B1

> I am trying to copy the first character of a cell and combine it with another
> row and place it in another row. I am trying to create usernames from two
[quoted text clipped - 7 lines]
> Jim Bob jbob
> Sally Richards srichards

Reply to this Message

kevin_jones06 - 17 May 2007 05:21 GMT

Thank you Mike this is perfect. Is there an easy way to check for
duplicates? and if ther is a duplicate to use the 1st Character + Last Name
plus a number? (i.e. jsmith10, jsmith15, jsmith24. I know this is not simple
but just thought I would ask. I have to do this 100 more times and I am
going to have to manually check for duplicates. Thank you for all of your
help.

> try this
>
[quoted text clipped - 12 lines]
> > Jim Bob jbob
> > Sally Richards srichards

Reply to this Message

Mike - 17 May 2007 05:45 GMT

Kevin
Freds example will make all user names to lower case if that's what you want
you could also change lower to upper to make all user names to be in upper
case

> Thank you Mike this is perfect. Is there an easy way to check for
> duplicates? and if ther is a duplicate to use the 1st Character + Last Name
[quoted text clipped - 19 lines]
> > > Jim Bob jbob
> > > Sally Richards srichards

Reply to this Message