| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using the LEFT formula for multiple cells
I'm going nuts trying to figure out if I have mulitple cells, and I want to
take the first character of each text string in each cell into one cell what do I use with the LEFT formula? Example. A1 = Hi B1 = Ouch C1 = What D=HOW or =LEFT(A1,1),(B1,1),(C1,1) Nothing I'm trying is working :( Your help is appreciated! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i use multiple cells to create a formula ? | Excel Discussion (Misc queries) | |||
| Look up formula, multiple cells | Excel Discussion (Misc queries) | |||
| Splitting cells using formula; RIGHT/LEFT not applicable | Excel Worksheet Functions | |||
| apply a formula to multiple cells | Excel Discussion (Misc queries) | |||
| If formula that looks at multiple cells and values, and then calul | Excel Discussion (Misc queries) | |||
Threaded Mode
