O
okanem
I have a number in Cell A1.
The number is 55658764422543
the number is generated by hand typing it, reading it from a barcode o
RFID tag.
The first 4 digits (5565) is the product serial no
The next 3 (876) is the store the product was sent to
The next 5 (44225) detail the components it took to make the product
The last 2 (43) are the colour of the product.
I want to be able to seperate the setcions of the number, i.e. first
digits into B1, then 3 digits into C1, then 5 digits into D1 the
finally 2 digits into E1.
I will use a VLookup then to reference what the components mean.
Can someone help me with the formula's that need to be entered into B1
C1, D1 & E1 in order to split the number.
Thanks in advance
Okane
The number is 55658764422543
the number is generated by hand typing it, reading it from a barcode o
RFID tag.
The first 4 digits (5565) is the product serial no
The next 3 (876) is the store the product was sent to
The next 5 (44225) detail the components it took to make the product
The last 2 (43) are the colour of the product.
I want to be able to seperate the setcions of the number, i.e. first
digits into B1, then 3 digits into C1, then 5 digits into D1 the
finally 2 digits into E1.
I will use a VLookup then to reference what the components mean.
Can someone help me with the formula's that need to be entered into B1
C1, D1 & E1 in order to split the number.
Thanks in advance
Okane