Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to collectly put data in each cell from magnetic card reader data
Hi
I try to get data from magnetic card reader into excel each cell from its data segment any idea, thanks simon |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to collectly put data in each cell from magnetic card reader data
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to collectly put data in each cell from magnetic card read
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to collectly put data in each cell from magnetic card read
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to collectly put data in each cell from magnetic card read
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Enter data and Function in same cell | Excel Discussion (Misc queries) | |||
ranking query | Excel Discussion (Misc queries) | |||
Cell data format | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions |