Creating user IDs based on info from multiple cells

mistawicket

New Member
Joined
Jun 16, 2008
Messages
25
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

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
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?
 
Upvote 0
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'?

:confused:
 
Upvote 0
You would use MID instead of LEFT

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

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


Hope that helps.
 
Upvote 0

Forum statistics

Threads
1,213,483
Messages
6,113,919
Members
448,533
Latest member
thietbibeboiwasaco

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top