Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pull first character from a cell?

Status
Not open for further replies.

PCBrandon

IS-IT--Management
Jan 6, 2007
17
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:

Code:
          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.
 
Played around with it some more, never realized how awesome Excel is:

=B1&Left(A1, 1)
 
you answered your own question... if you need a space in there do this:
=B1&" "&Left(A1, 1)
 
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.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top