| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Is it possible to put two formulas into one cell
I am using excel. In row A were first names and in row B there were last
names, I used the formula to combine them into row C. The names were in all caps, now I need to make them proper ex: instead of MICHAEL I want it Michael). Can someone please tell me how to do that, if it is even possible |
|
#2
|
|||
|
|||
|
Something like:
=PROPER(A1)&" "&PROPER(B1) Regards Trevor "dopey0331" wrote in message ... I am using excel. In row A were first names and in row B there were last names, I used the formula to combine them into row C. The names were in all caps, now I need to make them proper ex: instead of MICHAEL I want it Michael). Can someone please tell me how to do that, if it is even possible |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: Clear all cell entries EXCEPT formulas? | Excel Discussion (Misc queries) | |||
| Entering multiple formulas in one cell | Excel Worksheet Functions | |||
| Excel formulas based upon the color shading of a cell? | Excel Worksheet Functions | |||
| how do i copy a formula's result to another cell, without copying. | Excel Worksheet Functions | |||
| How to read a blank cell as zero for formulas? | Excel Discussion (Misc queries) | |||
Linear Mode
