A
Alan Calan
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
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