Barcodes
I'm trying to enter barcodes into a spreadsheet, but when scanned with a reader, the letters do not make it correctly. I'm reading a HEX number and the reader is translating it to something else. The numbers are making it, but I get the following:
A=A
B=X
C=J
D=E
E=>
F=U
What I want to know is if there is a way to automatically convert a number such as 041>59810300 to 041E59810300. My brain is a bit scrambledon this one and would appreciate whatever help you can give me.
Thanks again
Hello josephpatz,
Welcome to the Forum!
Are these barcodes being transferred to a single column of a worksheet? Is there ever a case where more than one letter appears in the code?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Assuming the string is in A1 then formula wise:
B1: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"X","B"),"J","C"),"E","D"),">","E"),"U","F")
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
The string will always 12 digits per cell, and since the number is HEX, the letters will be some to none. Thank you so much for the solution DonkeyOte.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks