Excel question

[PCBrandon]

Hi all,

I know how I can combine the text values of two cells into one using a formula, but now I need to combine the text value of one cell with the first character of a text value in another cell. I'll try to show you what I mean:

          A                    B                    C
1        Joe                 Shmoe            ShmoeJ

C1 combines the value of B1 with the first character of A1.

Any thoughts? Extra points if you can also show me how to get all the characters in C1 to be lowercase.

[PCBrandon]

Played around with it some more, never realized how awesome Excel is:

=B1&Left(A1, 1)

[pillainp]

Originally Posted by PCBrandon Hi all, I know how I can combine the text values of two cells into one using a formula, but now I need to combine the text value of one cell with the first character of a text value in another cell. I'll try to show you what I mean: A B C 1 Joe Shmoe ShmoeJ C1 combines the value of B1 with the first character of A1. Any thoughts? Extra points if you can also show me how to get all the characters in C1 to be lowercase.

Originally Posted by PCBrandon Played around with it some more, never realized how awesome Excel is: =B1&Left(A1, 1)

You are essentially right, just should have used the formula:
=(C1&LEFT(B1,1))

The formula you gave gives the result Jo1, whereas you wanted SchmoeJ.

To get everything in C1 in lowercase, just add the function LOWER in front of the whole thing enclosed in brackets, thus:

=LOWER(C1&LEFT(B1,1))

NPP