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