Need Function for Text To Columns
I have some data that I want to extract a number from. Here is an
example.
ABSD (P+3.9%)
I want to get at the 3.9, and I'm assuming I would want to use the "+"
sign and the "%" sign as delimiters somehow. Is there a function that
would help me do this all in one step?
I can get there using text to columns, but that is very manual and
requires several steps.
I'm out of ideas!!
Thanks.
--
JW
|