Sep05=Sep 5, 2007 instead of Sep 2005

[Alan Calan]

I already posted this on the generic excel newsgroup but maybe it
belongs in functions, so here it is.

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.

 

[Pete_UK]

If you have 3 or 4 spaces separating your area, then you can highlight
the cells and do Find & Replace (CTRL-H) to find 3 spaces and replace
them with something like the pipe character |. Then you could use this
as the delimiter for Data | Text-to-columns.

As for your first query, just apply a custom format to the cell(s) -
mmmdd

Hope this helps.

Pete