I am trying to extract numbers from a comma delimited list using excel function
The data looks like this:
1,58,,Private Information #1,After 59 seconds, your private estimate is that the final value will be $44.17
if the above data are in cell A1, I want to retrieve 59 in cell B1 and 44.17 in cell C1. The #of digits of a number might vary. Only numbers in the 5th and 6th comma-separated field are needed, and there will only be one number in each of those fields. For the 5th segment, the # will always be surrounded by the same text( i.e., After xxx seconds). For the 6th segment, it will always be the final characters, and they always follow a single $
I am not familiar with excel and would appreciate any help! Thanks in advance.
$
? Will that $ always be the only $ in the record, or at least in the last segment?