| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
refer to text
Try this:
=MID(A1,3,1) -- Biff Microsoft Excel MVP "Lowan Chan" wrote in message ... Hi, I have a text, e.g. "Finished" in A1, if I want the 3rd word from left "n" be displayed in B1, how to make the formula? and if A1 is a number, e.g. 12,520.70, how can a formula to display "5" in B1? thanks in advance. -- Lowan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to refer to a text piece in a VBA custom function? | Excel Discussion (Misc queries) | |||
| How can I refer to a worksheet using text in a cell? | Excel Discussion (Misc queries) | |||
| Refer to value | Excel Discussion (Misc queries) | |||
| refer | Excel Discussion (Misc queries) | |||
| Using 'If' refer to specific words in a cell containing text | Excel Worksheet Functions | |||
Hybrid Mode
