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:
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.
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.