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. |
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 |