| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
[Quickly!] Removing PrefixCharacter (i.e. leading, hidden apos
Wow! That's quick! Thanks.
"Tim Zych" wrote: With rngToFix .Formula = .Formula End With will work with formulas and/or constants. If a lot of formulas, turn calc to manual first. With rngToFix .Value= .Value End With for constants It can take an unterruptable long time if you are doing that against a huge sheet, so you might want to loop through smaller range areas and run it in sections.. -- Tim Zych SF, CA "David Mueller" wrote in message ... I used some code I found in the newsgroup to remove the leading, hidden apostrophe that identifies cell contents as a string data type -- but it's too slow. Is there a faster method than the "FOR EACH ... {remove prefix character} ... NEXT" I'm using? A common scenario for me is 10 worksheets, each with 200,000 cells of data each. In addition, there is one column on each tab from which I do NOT want to remove the prefix character. I'm not sure search & replace will work for me because I have legit apostrophes in my data. Thanks in advance. David |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing Leading Spaces | Excel Discussion (Misc queries) | |||
| Removing Hyperlinks Quickly | Excel Discussion (Misc queries) | |||
| Removing leading/trailing spaces | Excel Discussion (Misc queries) | |||
| Removing leading 0s | Excel Discussion (Misc queries) | |||
| Removing leading spaces | Excel Programming | |||
Threaded Mode
