I have a number in Cell A1.
The number is 55658764422543

the number is generated by hand typing it, reading it from a barcode or
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 4
digits into B1, then 3 digits into C1, then 5 digits into D1 then
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

Okanem


--
okanem
------------------------------------------------------------------------
okanem's Profile: http://www.excelforum.com/member.php...fo&userid=9301
View this thread: http://www.excelforum.com/showthread...hreadid=573778

First four digits can be returned by: =LEFT(A1,4), the last two can be
referenced via =RIGHT(A1,2) and the middle strings can be extracted by using
MID.

Look in Excel's help for more info on the syntax for MID, which I can't
quite remember.

Dave
--
Brevity is the soul of wit.


"okanem" wrote:


I have a number in Cell A1.
The number is 55658764422543

the number is generated by hand typing it, reading it from a barcode or
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 4
digits into B1, then 3 digits into C1, then 5 digits into D1 then
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

Okanem


--
okanem
------------------------------------------------------------------------
okanem's Profile: http://www.excelforum.com/member.php...fo&userid=9301
View this thread: http://www.excelforum.com/showthread...hreadid=573778

In B1 put...=LEFT(A1,4)
In C1 put...=MID(A1,5,3)
In D1 put...=MID(A1,8,5)
In E1 put...=RIGHT(A1,2)

Vaya con Dios,
Chuck, CABGx3



"okanem" wrote:


I have a number in Cell A1.
The number is 55658764422543

the number is generated by hand typing it, reading it from a barcode or
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 4
digits into B1, then 3 digits into C1, then 5 digits into D1 then
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

Okanem


--
okanem
------------------------------------------------------------------------
okanem's Profile: http://www.excelforum.com/member.php...fo&userid=9301
View this thread: http://www.excelforum.com/showthread...hreadid=573778

=LEFT(A1,4)

=MID(A1,5,3)

=MID(A1,8,5)

=RIGHT(A1,2)

"okanem" wrote:


I have a number in Cell A1.
The number is 55658764422543

the number is generated by hand typing it, reading it from a barcode or
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 4
digits into B1, then 3 digits into C1, then 5 digits into D1 then
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

Okanem


--
okanem
------------------------------------------------------------------------
okanem's Profile: http://www.excelforum.com/member.php...fo&userid=9301
View this thread: http://www.excelforum.com/showthread...hreadid=573778

Dear Okanem,

Number is in Cell A1 55658764422543

Fourmula should be in

B1 =LEFT(A1,4)
C1 =MID(A1,5,3)
D1 =MID(A1,8,5)
E1 =RIGHT(A1,2)


Aarif

"okanem" wrote:


I have a number in Cell A1.
The number is 55658764422543

the number is generated by hand typing it, reading it from a barcode or
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 4
digits into B1, then 3 digits into C1, then 5 digits into D1 then
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

Okanem


--
okanem
------------------------------------------------------------------------
okanem's Profile: http://www.excelforum.com/member.php...fo&userid=9301
View this thread: http://www.excelforum.com/showthread...hreadid=573778