how do I seperate information in one row into four columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mike - 12 Sep 2005 03:23 GMT

i use a scanner to scan 4 different codes on one unit. I have thousands of
units to scan.
I download the scanner into notepad.
I then import this into excel.
the downdload is all in one row.
I need to seperate the row into columns ,so that each unit is listed across
four columns.
right now I have to drag and drop
this is extremely time consuming
any help would be greatly appreciated.

Reply to this Message

David S - 12 Sep 2005 05:30 GMT

Um, this is a Microsoft Access newsgroup, for questions about that database
product - it sounds like you have a question about Microsoft Excel - try
asking over in that forum.

Having said that, your best bet is probably the Data -> Text to Columns
option from the menu.

>i use a scanner to scan 4 different codes on one unit. I have thousands of
>units to scan.
[quoted text clipped - 6 lines]
>this is extremely time consuming
>any help would be greatly appreciated.

Reply to this Message