replacing spaces?
hi
I have cells whose values are like:
K-TGF
PCR 90 Q
TGF 800 T
i want to check that if anywhere spaces " " or slashes "/"
or "-" comes i want to remove it so that fianlly my result
is:
KTGF
PCR90Q
TGF800T
what is the easist method?
thanks in advance
|