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.

cop, paste special. check transpose.

--


Gary


"Daniel M" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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.
>

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
news:eea1bDy$(E-Mail Removed)...
> cop, paste special. check transpose.
>
> --
>
>
> Gary
>
>
> "Daniel M" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>>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.
>>
>
>