| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unwanted single quote displayed in Formula bar
Cell A5 contains the text word TEST
Cell C5 contains the formula =IF(MID(A5,LEN(A5),1)="q",A5&"ue","") The result is a "blank" or a "" type of cell content since the result is FALSE. Now if I select this cell and copy it and then PASTE/Special into the same C5 position I get a single quote ' to appear on the formula bar but not in the cell when C5 is selected. Placing the formula = code(C5) into cell D5 gives #VALUE! Does anyone have an explanation as to what might be going on here? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Annoying single quote with ever new workbook | Excel Discussion (Misc queries) | |||
| using a single quote ' in SEARCH function | Excel Worksheet Functions | |||
| Remove single quote | Excel Worksheet Functions | |||
| Unwanted Zeros in Excel Chart Displayed Values | Excel Discussion (Misc queries) | |||
| Eliminating Single Quote Before Equals Sign | Excel Worksheet Functions | |||
Threaded Mode
