# Creating user IDs based on info from multiple cells

#### mistawicket

##### New Member
If I have a table that has a person's 1st name in A1, 2nd name in A2 & a number in A3, how can I have Excel take the first letter of A1, the whole last name from A2 & the number in a 3 to paste in 1 cell
A1 A2 A3
for example John Smith 1

would create an ID: JSmith1

I'd like a formula to calculate this, but I don't really know where to begin here...

### Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

#### Jonmo1

##### MrExcel MVP
Try this

=Left(A1,1)&A2&A3

Hope this helps...

#### mistawicket

##### New Member
wow... I did not think it would be that simple...
Thnks alot that worked & you all have helped me immensly!

#### mistawicket

##### New Member
It's not that important, but I was wondering out of curiosity, is there a way to format the cell so that it would display the new user ID in all lower case, reguardless of the caps from the original cells?

#### Evagrius Ponticus

##### Well-known Member
try,

=Lower(cell reference)

#### Jonmo1

##### MrExcel MVP
Yep,

=Lower(Left(A1,1)&A2&A3)

#### mistawicket

##### New Member
sweet! Thnx again all!

#### mistawicket

##### New Member
Working on a new project now, but using this same formula can I display just the second charater of a word in a cell?

For example,

In cell A1 I have the word 'CARD'

in my reference cell, G25 I just want the 2nd character 'A'

using the formula:

=UPPER(Left(A1,2))

how do I modify this formula to not display 'CA'?

#### Jonmo1

##### MrExcel MVP
You would use MID instead of LEFT

MID(cellref, beginning position #, how many characters)

=UPPER(MID(A1,2,1))

Hope that helps.

#### mistawicket

##### New Member
That does! Thank you very much!

Replies
9
Views
596
Replies
3
Views
653
Replies
2
Views
201
Replies
1
Views
212
Replies
1
Views
374

1,191,054
Messages
5,984,381
Members
439,883
Latest member
onions44

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back