[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
|