Data Import Problem

Good morning everyone,

I am importing data from another excel file that receives a dump of data from a database. Anyway, I have run into a problem with the date that is coming out of the original file. The date is in the format:

"Feb. 25, 2008"

The problem is the "." because excel is not recognizing this as a date. Is there anyway to search a string and remove this period?

Thanks in advance for your help!
tc

Found a solution:

FileDate = Replace(FileDate, ".", "", 1, vbTextCompare)

thanks,
tc