how to collectly put data in each cell from magnetic card reader data

[Electron-Serve Depot]

Hi
I try to get data from magnetic card reader into excel each cell from its
data segment
any idea, thanks
simon

 

[Bernard Liengme]

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

 

[Guest]

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]

You could use Text-to_Column (on the Data menu) to do this

 

[Guest]

Is there programing do this for me with out me to use text to column manually?