The Silence Map

Asked on Super User by Bebelens, 6 years ago. No reply there for at least a week.

How to format Excel cells to show only a certain part of the code my scanner scans from certain objects?

For ex: When I scan an qr code it shows: Column A1 vbmsavchjas asdhgaskhdgaskhdg_INX7642854858625 but I am only interest in the last characters: Column B1 INX7642854858625 I can use afterwards in a helper column the =left formula, but I´wonder if there is another option to show that part of the code while scanning, somehow to filter the code while scanning and return only the desired part in the cell. Probably some macro code?

This question is one of 1 report of the same problem:

How to format Excel cells to show only a certain part of the code my scanner scans from certain objects?

Nobody has answered it yet, here or anywhere.

Related problems

Question by Bebelens on Super User, licensed CC BY-SA. We show a short excerpt and link to the original thread as credit.