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

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

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