I am scanning a customers pdf 417 bar code that contains numerous = signs
between categories of data. I would like excel to actually tab all the data
that follows the equal sign to the next cell in the row each time it
encounters an equal sign. Is this possible? If so how?

If the bar code scanner that you are using has a "keyboard wedge"
interface then you would need to find out from the manufacturer of the
scanner if you can program the scanner the translate the equal sign
(=) to the TAB keystroke. Most bar code scanners that have a built in
keyboard wedge are programmable using special bar codes that are in
the users manual for the scanner.

If your scanner has a RS232 output then you must be using a "Software
Wedge" program to read in the data and convert it to keystrokes. In
this case you need to look in the software that you are using to see
if you can translate the equal sign to the TAB keystroke. The WinWedge
product from TAL Technologies has a full character translation table
that would allow you to do this. Their web site is at www.taltech.com



On Wed, 22 Aug 2007 12:56:01 -0700, David Gee
wrote:

I am scanning a customers pdf 417 bar code that contains numerous = signs
between categories of data. I would like excel to actually tab all the data
that follows the equal sign to the next cell in the row each time it
encounters an equal sign. Is this possible? If so how?