| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Apostrophes in Cell
I create a formula in a cell, I take the result (a number) and copy (values
to get rid of the formula) it into a cell to the left. When done there is an apostrophe at the beginning of the number. How can I get rid of this apostrophe with find/replace command. I have tried everything, it just comes back teling me it can not find a data... PS. I'm doing this with about 33,000 lines of data. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Apostrophes and Sorting | Excel Discussion (Misc queries) | |||
| Apostrophes in numbers with 16 characters | Excel Discussion (Misc queries) | |||
| Removing errant apostrophes | Excel Worksheet Functions | |||
| Dealing with hidden apostrophes... | Excel Discussion (Misc queries) | |||
| Problem using 'PROPER' with apostrophes | Excel Worksheet Functions | |||
Threaded Mode
