how to change 1 line of data to multiple rows
 

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.

how to change 1 line of data to multiple rows
 

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.

how to change 1 line of data to multiple rows
 

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.

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
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.