| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
LEFT &RIGHT formula on the same cell
I was trying to take off hyphen within a text string, such as "0100-00-000".
I used LEFT formula to return the first 4 digit. Then I used RIGHT formula on the same cell to return the last 3 digit but somehow the formula doesn't work. It won't give me a error message but just keep my formula in the cell. Please help and thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| How do I set a cell value based on a formula in another cell? | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| adding a formula in a cell but when cell = 0 cell is blank | Excel Worksheet Functions | |||
| Excel VB-Copy formula down until adjacent cell (left) is blank? | Excel Discussion (Misc queries) | |||
Threaded Mode
