Parse this string

[David]

XL2000
In A2, I have the following string:
Date: February, 2007
For reason, I have to leave the entire string in a single cell.

How can I parse out the month and year without the comma?

 

[JE McGimpsey]

One way:

=TRIM(SUBSTITUTE(MID(A2, FIND(":",A2)+1, 255), ",", ""))

 

[David]

JE McGimpsey wrote

One way:

=TRIM(SUBSTITUTE(MID(A2, FIND(":",A2)+1, 255), ",", ""))

Brilliant!! Thanks