Excel Help: Making text C&P usable
I'm pasting some text (runlines) in from the web and I'd like to be able to manipulate the numbers. Most are fine but some come in the form of " +1.5 -153" and I can't figure out a way (macro?) to easily convert it to a usable format. All I'm interested in is the last figure, "-153" in the example.
If anyone could be of help it'd be appreciated.
|