Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change data Series from a bar to a line after changing axis | Charts and Charting in Excel | |||
multiple rows with some dups where I need result on one line | Excel Worksheet Functions | |||
Change top line data and remove lower lies | Excel Programming | |||
Change top line data and remove lower lies | Excel Programming | |||
My rows are off by one row, ie. data on line 10 should line up wi. | New Users to Excel |