Go Back   Computer Forums > Welcome To Computer Forums .org > Social Lounge | Off Topic
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 11-18-2009, 12:10 PM   #1
Fully Optimized
 
jmacavali's Avatar
 
Join Date: Jun 2009
Posts: 4,867
Exclamation Excel Help! Rather Urgent too...

I need help with Excel. I have a list of users and I want to automate the process of creating usernames. I am going to add a number before the username, then it's the first 4 letters of their last name and the first letter of their first name then there will be an @XXXXX on the end. So here's an example for John Smith: ##SmithJ@XXXXX. What I need to know is if is a formula in excel that will let me do this? The Number (##) and the @XXXXX info will be the same on every users so that is constant. What will be different (obviously) is the names in the middle. Any ideas or thoughts.


EDIT:
I am able to get the ## and the @XXXXX and I can get the full first & last name. What I need is to be able to select only the first 4 letters of the last name and the first letter of the first name.

EDIT (again):
Sorry after posting I relized I was in the social lounge and not software where it belongs.
__________________

__________________
****************************************
Don't take life too seriously -- no one gets out alive. Plus, who wants to arrive to the hereafter in pristine condition wearing a suit and tie?
I want to slide in sideways, worn out, used up, hair a mess, clothes tattered, & screaming, "Whooo! What a ride!"
****************************************
jmacavali is offline   Reply With Quote
Old 11-18-2009, 12:25 PM   #2
j03
~~~~~~~~
 
Join Date: Jan 2005
Location: Wales
Posts: 5,556
Send a message via MSN to j03
Default Re: Excel Help! Rather Urgent too...

OK, I've just had a go and I came up with:

=$G$2&B3&LEFT(A3,1)&"@"&$G$3

It's probably best if you actually see the spreadsheet:
http://78.32.84.162/excel/Username%20Generator.xls
__________________

j03 is offline   Reply With Quote
Old 11-18-2009, 12:42 PM   #3
Fully Optimized
 
jmacavali's Avatar
 
Join Date: Jun 2009
Posts: 4,867
Default Re: Excel Help! Rather Urgent too...

Yes the Left command is just what I needed. Thank you!

Here's what my formula ended up being: ="##"&LEFT(B2,4)&LEFT(A2,1)&"@XXXXX"

Of course "##" is the actual number I wanted in there and "@XXXXX" is the ending I wanted on it. The quotes are there to indicate 'static' text and column B is the last names and column A are the first names. The Left command indicates it will look in the cell (B2) and take the first 4 characters starting at the left.
__________________
****************************************
Don't take life too seriously -- no one gets out alive. Plus, who wants to arrive to the hereafter in pristine condition wearing a suit and tie?
I want to slide in sideways, worn out, used up, hair a mess, clothes tattered, & screaming, "Whooo! What a ride!"
****************************************
jmacavali is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 03:40 PM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0