how to change 1 line of data to multiple rows again...

D

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.

Copy, paste special, transpose does not work for this...

Any ideas? Thanks.
 
A

Alok

Hi Daniel,

Put the starting stringin A1. Enter the following formua in A2
=MID($A$1,1+(ROW()-2)*9,9)
And then extend the formula into cells A3 and A4.

Alok
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top