Re: Programing - TEXT - EXCEL

Tech-Archive recommends: Fix windows errors by optimizing your registry

Jose,

Are last name and first name in the same column or in 2 different columns?

This can be done with a formula. No need for code/macros (you are posting
in excel.programming...excel.misc or excel.work***.functions would be
better)

LName & FName in 2 different columns:
If "LastNames" is in A1, "FirstNames" is in B1 and your data starts in A2,
then enter this formula in C2:

=LOWER(LEFT(B2,1) & A2)

LName & FName in the same column:
If there is a label in A1 and your data starts in A2, then enter this
formula in B2:

=LOWER(MID(A2,FIND(",",A2)+1,1) & LEFT(A2,FIND(",",A2)-1))

which ever way you use, copy the formula down as far as you need.

HTH,

Conan




"Jose Cabral" <JoseCabral@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2FC1D487-C816-4A5A-997A-221A9945A355@xxxxxxxxxxxxxxxx
I have a column with LastNames,FirstNames eg. (Alcantara,Alice). I need to
genetate a new column with the first initial of the Firstname and the
LastName eg (aalcantara). Can this be done in excel? if YES, how can be
done?
Please advise



.

Quantcast