Greetings,
We have a scanner we use to scan a barcode for blood units for a hospital
into an Excel spreadsheet. The scanner reads the entire barcode, but we
want to remove 00 at the end of the scanned string. If there isn't 00
at the end, make it null cell. We are using the correct
Are the entire code only numerics, or are they alpha numeric?
On Mon, Jul 29, 2013 at 10:44 PM, Don Barton donaldb...@gmail.com wrote:
Greetings,
We have a scanner we use to scan a barcode for blood units for a hospital
into an Excel spreadsheet. The scanner reads the entire barcode, but we
Hi Sam,
When the barcode is scanned it reads in alphnumerics and symbols. The only
symbol we have to worry about is the = sign at the beginning. In the
example above I just asked about the 00 at the end. If I can get the
code for the 00, I should be able to figure out the code for the = at
the
Hey
You can do do with formula
=MID (A1, 2, LEN (A2)-3)
HTH//Cheers
On 29 Jul 2013 23:48, Don Barton donaldb...@gmail.com wrote:
Hi Sam,
When the barcode is scanned it reads in alphnumerics and symbols. The
only symbol we have to worry about is the = sign at the beginning. In the
example
try this code
Sub trunkit()
Dim Ctx As Range
'We use this method to get dynamic Record count in C Column
For Each Ctx In Range(C2: Cells(Range(C:C).Rows.Count,
3).End(xlUp).Address)
If Right(Ctx, 2) = 00 Then
'Replace = sign, from removed 00 string
vba, thanks for your suggestion, which will work fine in formula.
De Premor - the code works exactly as designed with our barcode scanner!
Our Blood Bank supervisor is impressed!
Thanks you so much for your quick reply and expert help.
Don
On Mon, Jul 29, 2013 at 12:37 PM, De Premor