| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I remove leading apostrophes in Excel?
I have a large Excel spreadsheet made up of about 30,000 cells.
Most of them have a leading apostrophe (') in them, whether they are numbers or text. I would like to remove all the leading apostrophes without having to do it manually, cell by cell. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove text leading zero in text string | Excel Worksheet Functions | |||
| How do you remove a checkbox from an excel spreadsheet?? | New Users to Excel | |||
| How do I remove decimals of IP address in excel? | Excel Discussion (Misc queries) | |||
| How do I remove blank rows in Excel? | Excel Discussion (Misc queries) | |||
| How to remove an Excel Main Menu item inserted by .xla file | Excel Discussion (Misc queries) | |||
Threaded Mode
