Need help with Excel Macro

Tsaico

Platinum Member
Oct 21, 2000
2,669
0
0
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

Senior member
Jun 11, 2003
274
0
0
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

Junior Member
Dec 2, 2005
11
0
0
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?
 

Tsaico

Platinum Member
Oct 21, 2000
2,669
0
0
Only that I didn't even know that LEFT command even existed... thanks guys! I will look into this.
 

koby123

Junior Member
Dec 15, 2005
3
0
0
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