If all the data gets put into one cell and has to be separated, you can use
the spreadsheet's 'Text to Columns' feature to parse out the data into
columns. It will take a little practice to determine if selecting 'fixed
width' or 'delimited columns' is most suitable but well worth the effort if
you have a lot of data to process.
On Sat, May 25, 2013 at 2:22 AM, Donk <d.knier...@verizon.net> wrote:
> **
>
>
> I think most any usb barcode scanner will work. If you put the cursor
> into a Excell cell, and then scan a barcode, the info from the code
> should appear in the cell. But... I dunno if you'll be able to get the
> different results from a single code to appear in separate cells? It
> might just put ALL the info from a code into one cell - and you'll have
> to copy/paste it into the cells you want (serial number, manufacturer,
> price, etc). It might require specialized software to automatically
> separate the data into different fields. I know a librarian who uses a
> scanner to scan circulation info from books - but she uses a special
> library program to sort the data.
> But then... I've never actually used a scanner so I'm mostly just guessing.
>
> Donk
>
> On 5/24/2013 6:54 PM, james b wrote:
> > ok guys here is my situation, i am working for a company that installs
> exede, and i have to do a inventory of all my equipment that i have at my
> house once a week, it all has bar codes and then has the information on it,
> my question is could, can i get a barcode scanner, scan all this in and put
> it into a exel doc. and make it easyier to do for me, because i have 12 to
> 20 units a week and it gets to be a pain to punch it all in.
> >
> >
> >
>
>
>
[Non-text portions of this message have been removed]
------------------------------------
If you have any questions or problems with any aspect of this site, please feel
free to contact me directly bi...@optonline.net Please do not post personal
issues directly to the group.
To unsubscribe from this list, send an email to
a-1-computer_tech-unsubscr...@yahoogroups.com
Thank you for using A-1 Computer TechYahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/A-1-Computer_Tech/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/A-1-Computer_Tech/join
(Yahoo! ID required)
<*> To change settings via email:
a-1-computer_tech-dig...@yahoogroups.com
a-1-computer_tech-fullfeatu...@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
a-1-computer_tech-unsubscr...@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
