Need help with Excel Macro

[Tsaico]

I have a series of input that are put into a excel sheet via a magnetic card reader. The excel sheet is to have the gift card number, but I don't need the site information, just teh 16 digits of the actual card. So when a card is swiped, the input looks like this

;1234567890123456?1234567:

and I want to get rid of the informaiton between the "?" and the ":". how do I do this, or where is a good site for programming macros?

 

[AtTheGates]

You don't really need a macro for that. Use the worksheet function LEFT. It would look something like =LEFT(<cell with the full ID>, 17). Or if you don't want the ; at the start, =MID(<cell with the full ID>,2,16).

VBA has the same functions if you want to do it with a macro.

 

[Attack Cod]

I don't think you'd even need a Macro for this, just use the "left" function.

So, if your number was in cell A1, put this in cell B1:

=LEFT(A1,17)

Which returns:

:1234567890123456

You could get rid of the leading ":" any number of other ways.

Any reason why you need to use a macro instead?

 

[Attack Cod]

I swear when I set out to answer your Q the above post wasnt there...

 

[Tsaico]

Only that I didn't even know that LEFT command even existed... thanks guys! I will look into this.

 

[koby123]

Hello Edward
I was searching the Internet for a solution and reached your ad in the forum http://forums.anandtech.com/messageview...atid=33&threadid=1753068&enterthread=y
I was wondering if you can help me with something.

I am looking for a solution that can help me import data directly from my magnetic card to my excel sheet, but it seems that it is not so easy.
I will be grateful if you can help me or send me some tips on with this matter.

Thanks in advance
Koby