Parse data to 2 columns and remove unwanted data with VBA

I am dumping data from a text file that looks like this in Excel

Bob North PAYEE 6S290 $********2,103.00
Joe Smith PAYEE 6G621 $**********220.21
Treasurer PAYEE 0001635838 $*******20,000.00
Dolly South PAYEE D36922 $**********894.25
Jim East PAYEE 0020807012 $*******20,000.00
Billy Bob PAYEE D36921 $*******20,000.00

All the data is in column C. All I need is the data below. The name would be in column C and the number would be in column D. What would be the easiest way to accomplish this with vba. I tried using text to columns but some of the Payee data would think it is a number and transpose it to look like this example( 6S290 would look like 6.00E+90).

Bob North
Joe Smith
Treasurer 0001123467
Dolly South
Jim East 0098765423
Billy Bob

Thanks for the quick reply.

I was hoping to do this in vba and I need the name in one column and just the number in a different column. No payee.

Possibly...

Sub testparse()
    Dim v As Variant, w As Variant
    Dim x As Long
    Dim a As String, b As String

    With ActiveSheet
        v = Intersect(.Columns("C"), .UsedRange)
        w = v
        For x = LBound(v) To UBound(v)
            a = Left(v(x, 1), InStr(1, v(x, 1), "PAYEE") - 2)
            b = Mid(v(x, 1), InStr(1, v(x, 1), "PAYEE") + 6, InStr(1, v(x, 1), " $*") - (InStr(1, v(x, 1), "PAYEE") + 6))
            v(x, 1) = a
            If IsNumeric(b) Then
                w(x, 1) = b
            Else
                w(x, 1) = ""
            End If
        Next x
        Intersect(.Columns("C"), .UsedRange) = v
        Intersect(.Columns("C"), .UsedRange).Offset(, 1) = w
    End With
End Sub

That is leaving some of the data I don't want (7D260) and some of the data looks like 7.00E+29 & 6.00E+81.

In your example, what is the criteria for keeping the numbers after the Treasurer and Jim East? I assumed numeric ...?
As for the scientific notation, you probably need to format column d as text beforehand.

Yes, I formatted column D and it fixed everything. Thanks everyone for you help.