Hi All,
Good day. My card reader will capture 12 digit from employee ID card into excel sheet. Default card will be ID 88******1100, when the ID encoded to 88******1200, I still manage to capture the data by use REPLACE formula. But now when encoded card with last 4 digit become 1300,1400,1500,1600 ...my code unable to recognize anymore. Any IDEA / help very appreciated..
Thank you
Bookmarks