how to change 1 line of data to multiple rows

[Daniel M]

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.

 

[Gary Keramidas]

cop, paste special. check transpose.

 

[Daniel M]

Nope, this doesnt work. It will work for going from columns to rows but not
the other way around. it doesnt know how long the data is to break it apart.
Any other ideas?

dm.