| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and Replace
I have approximately 10 names wrapping in an Excel cell throughout a
spreadsheet. Some of the names are misspelled or inverted. When I attempt to find and replace a name, Excel gives me an error message that states: "MS excel cannot find any data to replace. Check if your seach formatting and criteria are defined correctly. If you are sure that matching data exists in this workbook, it may be on a protected sheet. Excel cannot replace data on a protected worksheet." These names were copied into Excel from another application (iPro). Anyone have any ideas how to get around this situation? Thanks in advance for any assistance that can provided. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
| where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
| find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
| Find then If then Replace | Excel Worksheet Functions | |||
| find replace cursor default to find box | Excel Discussion (Misc queries) | |||
Hybrid Mode
