how do I seperate information in one row into four columns

M

mike

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

David S via AccessMonster.com

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.
 

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

Similar Threads

How do I change margins to make a leaflet with four columns? 3
Copying rows based on four digits and finding a match 6
How do I seperate information using a delimiter 4
Extracting data from Multiple columns to a Single row 3
How to rank multiple columns by different contribution levels to rankin Excel? 4
Concatenate info from columns into one row. 1
Copying Rows with values in column A pasting in a new doccument and saving that doc 1
How do I allow blank columns in a .CSV file? 8

Top