Help cleaning up some Strings
Where do you insert this line of code in excel? in the text box?
ZOCOR
"Don Lloyd" wrote in message
...
Hi,
If all the cells are in the format shown then extracting the value will
convert it to a number, minus underscores.
e.g. activecell= Val(activecell)
Should you want to keep it as as text then Activecell=
Str(Val(Activecell))
would do it.
If neither of the above please post back.
regards,
Don
"43N79W" wrote in message
...
Excel 2002
Windows XP Pro
Suppose in column A I have the following kinds of String values
12________
24___
17______
34__
24____
I'd like to write a Macro that will remove all of the underscores
(char(95)
i believe). How would you go about doing that? The number of
underscores
in any given string will vary, but they'll always be at the end of the
string.
TIA
-gk-
--
=================================================
The creative act is not the province of remote oracles or rarefied
geniuses
but a transparent process that is open to everyone.
-Greg Kot in Wilco Learning How To Die-
|