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 wrote:
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
Hey
You can do do with formula
=MID (A1, 2, LEN (A2)-3)
HTH//Cheers
On 29 Jul 2013 23:48, "Don Barton" 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 above I just
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 "=" a
Are the entire code only numerics, or are they alpha numeric?
On Mon, Jul 29, 2013 at 10:44 PM, Don Barton 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
> want to remove
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 symbo
