| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing leading single quote (') from cells with Search/Replace
I have put together a sheet full of formulas. When creating the formulas I
put a single quote in front of all the equal signs (ie. '=A1+A2) so that I could see the formulas. My strategy was to do a Search/Replace to make the conversion to formulas. Search for: '= Replace with: = To my chagrin, the Search cannot find the single quote mark since it does not show up in the cell. Please help!! My sheet has over 500 lines. I can't go back through te cells one-by-one. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel should merge cells without removing content of any cell | Excel Discussion (Misc queries) | |||
| Is it possible to show leading zeros for "number" cells? | Excel Discussion (Misc queries) | |||
| Removing single quote from an excel sheet | Excel Discussion (Misc queries) | |||
| How to change a single cell's width | Excel Worksheet Functions | |||
| single quote 10-digit number that has leading zeroes & then conca. | Excel Worksheet Functions | |||
Threaded Mode
