Try this with the below setup.
=LEFT(B1,2)&A1&RIGHT(C1,2)
Karl H. Hehr
Technology/Curriculum Director
South Hamilton CSD
www.s-hamilton.k12.ia.us
515.827.5418 (W)
515.209.9767 (C)
515.827.5368 (F)
Luddite by Degrees
1) Anything that is in the world when you're born is normal and
ordinary and is just a natural part of the way the world works.
2) Anything that's invented between when you're 15 and 35 is new and
exciting and revolutionary and you can probably get a career in it.
3) Anything invented after you're 35 is again the natural order of
things
--- Douglas Adams
On Aug 4, 2009, at 9:03 AM, Mitch Mueller wrote:
This gets me somewhere but I'm not getting anywhere with it. I think
you
made some mistakes and I'm trying to figure them up.
-----Original Message-----
From: info-tech-ow...@aea8.k12.ia.us [mailto:info-tech-ow...@aea8.k12.ia.us
]
On Behalf Of Stanzel, Matt
Sent: Tuesday, August 04, 2009 8:43 AM
To: info-tech@aea8.k12.ia.us
Subject: RE: [info-tech] Excel Help I hope
Mitch, something like this should work:
Column A = last name, Column B = first name, Column C = year of
graduation
A B C
1 Mueller Mitch 2010
2 Stanzel Matt 2011
=SUBSTITUTE(TRIM(UPPER(CONCATENATE(LEFT(A2,1)),A1,RIGHT(A3,2))),"
","")
The "Substitute" portion will remove spaces from the username and
replace with no space.
-----Original Message-----
From: Mitch Mueller [mailto:mmuel...@emmetsburg.k12.ia.us]
Sent: Tuesday, August 04, 2009 8:28 AM
To: info-tech@aea8.k12.ia.us
Subject: [info-tech] Excel Help I hope
Trying to write a excel function. Wanting to make a csv file and need
to
make a fuction that reads.
Username is first initial, last name and than if their grade it 12 it
corresponds to the year they graduate. So it would look like
mmueller10
If you have any idea on what we could do for that it would be awesome
cause
I don't want to have to go through all of our student and add than
manually
if I didn't have too.
Thanks
Mitch Mueller
Emmetburg CSD
---
[This E-mail scanned for viruses by Declude Virus on the server
aea8.k12.ia.us]
---------------------------------------------------------
Archived messages from this list can be found at:
http://www.mail-archive.com/info-tech@aea8.k12.ia.us/
---------------------------------------------------------
---
[This E-mail scanned for viruses by Declude Virus on the server
aea8.k12.ia.us]
---------------------------------------------------------
Archived messages from this list can be found at:
http://www.mail-archive.com/info-tech@aea8.k12.ia.us/
---------------------------------------------------------
---
[This E-mail scanned for viruses by Declude Virus on the server
aea8.k12.ia.us]
---------------------------------------------------------
Archived messages from this list can be found at:
http://www.mail-archive.com/info-tech@aea8.k12.ia.us/
---------------------------------------------------------
---
[This E-mail scanned for viruses by Declude Virus on the server aea8.k12.ia.us]
---------------------------------------------------------
Archived messages from this list can be found at:
http://www.mail-archive.com/info-tech@aea8.k12.ia.us/
---------------------------------------------------------