Turn the macro recorder on, do a DataText To Columns with a space
delimiter, this will give you the code.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Biochemist" wrote in message
...
I would like to know how to write a specific macro that handles the
following
format:
download a series of alpha and numbers, the alpha values are always second
in the location, example would be
Cell A1 = 10102007 truckstop $15.32 $4449.31
Cell A2 = 95102007 office stop store center $22.32 $3465.89
I would like to have the macro able to place dates into A column dates, B
column vendor name, C column the first $ value, and in the D column the
last
$ value, and have this run for the complete spreadsheet.
Thanks in advance