Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get data from magnetic card reader to each cell
Subject: how to collectly put data in each cell from magnetic card read
11/5/2006 9:20 PM PST By: simon In: microsoft.public.excel.worksheet.functions Is there programing do this for me with out me to use text to column manually? "Bernard Liengme" wrote: You could use Text-to_Column (on the Data menu) to do this -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "simon" wrote in message ... Hi Bernard Liengme data read from megnetic card reader as following %BAS49247 ^STRONG/MORRI ^ E61158? what i want to do is when card scanned BAS49247 go to column A with out % STRONG / MORRI go to column B without ^ and E61158 go to column C without ^ and ? and then cursor jump down to column A row 2 thanks "Bernard Liengme" wrote: If the data is segmented correctly, Excel will tab to new column It does so with Nova Scotia drivers licences OR use Data| Text to Columns best wsihes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Electron-Serve Depot" wrote in message ... Hi I try to get data from magnetic card reader into excel each cell from its data segment any idea, thanks simon Try to get data from magnetic card read into excel each cell automatically every time i scan the card data read from megnetic card reader as following : %BAS49247 ^STRONG/MORRI ^ E61158? each time when card scanned BAS49247 go to column A with out % STRONG / MORRI go to column B without ^ and E61158 go to column C without ^ and ? And then cursor jump down to column A row 2 thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Entering data into Excel from a check reader / scanner | Excel Discussion (Misc queries) | |||
Stock Card Data Base | New Users to Excel | |||
how to collectly put data in each cell from magnetic card reader data | Excel Worksheet Functions | |||
On template Bus. Card How to make one Card into all 10 cards | Setting up and Configuration of Excel | |||
trendind data from compact flash card to excel | Excel Worksheet Functions |