| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Strip out the ' at the beginning of cell contents
Hi All the entries to my cells in column A seem to have a ' symbol at the start of them. A formula I'm using in column B is failing because of this. When I manually remove the ' from the formula box , my formula works. Does anyone know how to strip out the leading ' from all the cells , and leave all the real data intact? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert character at beginning of cell without changing contents | Excel Discussion (Misc queries) | |||
| Strip Values From Cells To Create New Cell Value | Excel Discussion (Misc queries) | |||
| Strip leading spaces from cell | Excel Worksheet Functions | |||
| Macro to remove contents of cell and move all other contents up one row | Excel Discussion (Misc queries) | |||
| How can I strip a new line /nl in a cell in Excel globally | Excel Worksheet Functions | |||
Threaded Mode
