cop, paste special. check transpose.

--


Gary


"Daniel M" wrote in message
...
I have a macro that formats column data and imports it into an access database.
The data is scanned in with a barcode scanner. The problem is i have to hit
enter in between each item. All items are the same length. I would like to see
if i can format the data in a row to a column with a macro after entry.

ie: All data in A1 =
02-00123402-12345602-845645
where all number are 02-xxxxxx then repeats with the next item.

I would like the data to be as follows:
A1 02-001234
A2 02-123456
A3 02-845645
where the data is in column A rows 1-3.

Any ideas? Thanks.