I copied into Word, a property assessors records (Owner's Directory)
online for a given community in Florida.  Then I went into the
indivdual proerty manually  and recorded all sales from Jan 2000 to
current and I updated each line of the owner's diectory by adding 3 to
5 spaces after the address and then putting the square footage.  The
next column had the word unincorporated so I killed that in in their I
put in the date sold and the amount like this:

Sep 05   $127,000  

to conserve keystrokes I wentr to this:
Sep05     127,000

The I realized it would be a good idea to add selling price per sq ft
and then I realize I was stupid not to use Excel

So, I brought the entire 50 pages to Excel and with Text to Columns I
separated the date and the price.  

Problem is, Sep05 became Sept 5, 2007. How can I fix these?

Also, in the column where the street address was there is a street
number, street name, condo # and I added the sq footage just as a
number so it looked like this:

4510 Valencia Isle Court 410    1325

         or

4510 Valencia Isle Court A    1325

where 1325 is the sq footage and that is what I need to separatewith
Text to Columns.  If I select "space" as the delimiter it puts
everything in column, which may be the answer, but I'd rather just
punchout the 1325.

Thanks in advance,

Alan

PS: I don't know macros or visual vasic and I have Excel 2003