|
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 05:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com