View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David David is offline
external usenet poster
 
Posts: 31
Default Parse this string

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?

--
David