| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replacing Apostrophize at Beginning of Cell
I have a spreadsheet where columns D through N have SOME data with
apostrophies before the data (e.g., '777, 'DCH8, 'GlobalExpress). Some data does, and some data doesn't have the apostrophe and they are all mixed together. This becomes a pain when trying to compare cells (e.g., I want to compare replace DCH8 with 'DCH8). When I go to find replace, if I put find ' and replace with nothing, it does not find anything. How can I get rid of all of the ' in front of the data? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I delete a space in the beginning of a cell... | Excel Discussion (Misc queries) | |||
| Strip out the ' at the beginning of cell contents | Excel Discussion (Misc queries) | |||
| Finding average beginning at first cell in row 0? | Excel Discussion (Misc queries) | |||
| Find the beginning Cell of a Range | Excel Discussion (Misc queries) | |||
| Identification of "<" character at beginning of cell | Excel Worksheet Functions | |||
Threaded Mode
