| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Barcode Scan and separate data into respective columns
I'm trying to scan a barcode. I have multiple entries in a single cell that I
want to separate into their respective columns. For example the format of the barcode scan is "123-454-345 r2.1 7012495" Each entry is separated by a space and I need each entry to be put into their designated columns. After I scanned the barcode, I used the Text to Column tool which gives me the result I want, but I don't want to do this for every entry. Is this possible to create some formula, function, or macro to accomplish my needs? I need help please!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Scan from a document to excel with separate cells | Excel Discussion (Misc queries) | |||
| Looking up data in a column, then returning values of respective row | Excel Discussion (Misc queries) | |||
| barcode scan changes last 2 digits in excel 2003 | Excel Worksheet Functions | |||
| HOW CAN I SCAN DATA WITH COLUMNS AND ROWS DIRECTLY INTO SPREADSHE. | New Users to Excel | |||
| How do I copy data (word) into respective cells when the data bei. | New Users to Excel | |||
Threaded Mode
