Re: Excel Help: Making text C&P usable
If there is always a space between the last number you are interseted in and the rest of it you can play around with the text functions. For instance, if F15 is the cell you have put "+1.5 -153" you can get -153 using this:
=RIGHT(F15,SEARCH(" ",F15,1))
If there are leading spaces you can increase the last "1" in the search function to start looking later in the string.
|