One way to do things would be to use formulas in Excel to extract the
data and put it into the correct cells.
For example, suppose that your data is:
123-454-345 r2.1 7012495
I assume that there are three fields:
123-454-345
r2.1
7012495

I also assume that the data encoded in the bar codes in the first two
fields will always be the same length - if it is not fixed length (at
least the first two fields) then the following technique will not
work.

If you scan the above data in cell A1 and then put the following
formulas in B1, C1 and D1 then you should get what you want:

Cell B1 formula: =LEFT(A1,11)
Cell C1 formula: =MID(A1,13,4)
Cell D1 formula: =MID(A1,18,20)

Another approach that you could take is to reprogram your bar code
scanner to convert the space characters to TABs. I assume that your
bar code scanner has a "keyboard wedge" interface so that it enters
the data as keystrokes into whatever application has the input focus.
Most keyboard wedge scanners come with a programming manual that
contains a number of special bar codes that you can scan to program
how the scanner works. If your scanner can be programmed to translate
individual characters to specific keystrokes then you should be able
to translate the spaces in the bar codes to tab keystrokes so that the
data would get appear in Excel in separate columns.
If your bar code scanner has a RS232 output then you must be using a
"software wedge" to input the data into Excel. If this is the case
then you could check the settings in the software to see if there is a
way to translate spaces to tabs. If you are using WinWedge from TAL
Technologies (www.taltech.com) then there is a translation table in
WinWedge that you can use to translate spaces to tabs.


On Wed, 4 Apr 2007 15:04:01 -0700, ExcelNewbie
wrote:

123-454-345 r2.1 7012495