Pull first character from a cell?

[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)

 

[joeny1980]

you answered your own question... if you need a space in there do this:
=B1&" "&Left(A1, 1)

 

[SPV]

To get the lower case in C1:
=LOWER(B1&LEFT(A1,1))

For more ideas, use the fx button just above the column headings (A B C etc). It opens the Insert a Function wizard which has its own built-in function search utility. Choose Text from the Category drop-down list.

 

[yogia]

Hi PCBrandon:

Or even ... =B1&LEFT(A1)

if the second argument in using the LEFT function is omitted, it will be taken as 1 by default.

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC

http://www.energyefficientbuild.com