I have columns populated as follows:
variable length characters = variable length characters
for example,
TVPosPctSP = 0.00 percent
I want to copy the entire column,
then in the 1st column delete all of the characters in each cell that
precede the equal sign,
and in the second column delete all of the characters in each cell that
follow the equal sign. (and I can include the equal sign in one of those
passes)
is there a wildcard character that identifies everything before an
associated parameter, such as the equal sign? (or everything after an
associated parameter, such as the equal sign?)
thank you