how do I seperate information in one row into four columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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