Programing - TEXT - EXCEL
 

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

Programing - TEXT - EXCEL
 

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.worksheet.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" wrote in message
...
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

Programing - TEXT - EXCEL
 

Hi Conan:

Thank you very much.

"Conan Kelly" wrote:

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.worksheet.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" wrote in message
...
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