Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
replace ' in cells
I have a spreadsheet where all the fields (except those with numbers) have a
' before the data in the cell. The ' does not show up in the cell, but only in the formula line. CTRL+H does not work, nor does it work using the ~ with the ' (either before or after the ' character). I need to remove this character in order for my formulas to work. The spreadsheet has over 10K rows and 170 columns. Thank you, Susie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do you want to replace the destination cells? | Excel Discussion (Misc queries) | |||
Checking the Cells in Sheet1 with Cells in Sheet2 and replace | Excel Worksheet Functions | |||
Replace #VALUE! in cells of a worksheet | Excel Discussion (Misc queries) | |||
How to find multiple cells/replace whole cells w/data | Excel Discussion (Misc queries) | |||
Replace cells with blank | Excel Worksheet Functions |