I've written a formula that takes a scan from a barcode "010500022346936951723020110100043", in the next cell, it finds the digits between the "01" in the beginning and the "17" towards the middle. I would prefer to have a userform where TextBox10 is where the raw scan populates, and label 13's text is the string between the two numbers while omitting the 0 in the beginning if possible.
Here's the formula that I used, utilizes 3 cells which is why it's so muddy: =IFERROR(MID(LEFT($AI14,IFERROR(FIND("17",$AI14),FIND("10",$AI14)-1)),FIND("01",$AI14)+2,LEN($AI14)),"")
Then in the next cell, I use the Value function to remove the 0 from there.
Is there a way to do this, pulling the same data from TextBox10, then omitting the 0 if it exists in the beginning of the new number and then names Label13?
wow, that sounds confusing. I haven't tried anything in VBA yet, I haven't found anything that really fit what I was looking for.