concatenating partial cells
Posted by debbie on December 01, 2001 9:37 AM
I need to create column m to list e-mail addresses that consist of first letter of firstname(ex. cell f3 alicia), first three letters of last name (ex. cell e3 smith), and last four digits of ssn(ex. cell g3 000-10-9999) and then add @nsu.edu. so my final result in m3 should read asmi9999@nsu.edu. Do I have to create new cells with only th info i need for m3 or can i concatenate partial cells? thanks for any help!
Posted by Mike Winters on December 01, 2001 9:59 AM
Hmm. I tried using
=CONCATENATE((LEFT F1,1), (LEFT E1,3), (RIGHT G1,4)), but XL97 gives me an error when I try to hit enter. I am fairly new to VBA and formulas in XL, but maybe that will give you an idea. Sorry I couldn't help more.
Sincerely,
Mike Winters
United States Army
Posted by Mike Winters on December 01, 2001 10:12 AM
Ok, use this:
=LEFT(F1)&LEFT((E1),3)&RIGHT(G1,4)&L1
this assumes that "@nsu.edu" is in L1
also, anything preceding with @ will cause an error if the cell is not formatted to text.
Sincerely,
Mike Winters
United States Army
Posted by Mike Winters on December 01, 2001 10:16 AM
Forgot to mention:
Forgot to mention: if you dont have a cell with @nsu.edu in it, you can just put it in the formula, IE.
=LEFT(F1)&LEFT((E1),3)&RIGHT(G1,4)&"@nsu.edu"
and that will do the same thing. Sorry about that.
Mike Winters
United States Army
