I am making a barcode system and I want to be able to display the information given in the barcode in the cells next to it. For example I am using my program to track boxes with replacement orders in them as they go through the facility. The information given in my barcode is the family of the product and the box letter. However the family names vary in length so I cant use a simple Left Or Right function. I want the entire family name to be displayed in the cell to the right. Please help! :)
Well, if our partnumber is a standardized length, you could test it with LEN, then subtract the number of digits your partnumber is? Would that work. So as in the following:
A1 has "partname0012345678"
If cell B1 had =Len(A1), it would display 18. So then take cell C1, and have it look at =Left(A1,B1-10).
Give that A go!
I have said it once, I will say it again. IT!