The data looks like this:

**1,55**

**,**

**,**

**Private**

**Information #1 for UB**

**,After**

**56 seconds, your private estimate is that the final value will be $51.19**

If the above data are in cell A1, I want to retrieve

**UB**in cell B1 and

**56**in cell C1 and

**51.19**in cell D1. So, only the last characters in 3rd filed and only numbers in the 5th and 6th comma-separated field are needed, and there will only be one number in the 5th and 6th field. 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.