Our products have a sku number that contains information on the product
weight and mail class it is to ship by. How do I get excel to recognize just
that portion of a sku so that it can "see" the mail class and weight?
As an example - here is a sku 00-1007-133
The number 1007 tells us the mail class is First Class (1) and the weight is
7 ounces (7). How can I get excel to read just the 4 numbers in the center of
the sku?

Thanks so much for any help you can offer.

If your sku is in A1, =MID(A1,4,4)

"snd679" wrote:

Our products have a sku number that contains information on the product
weight and mail class it is to ship by. How do I get excel to recognize just
that portion of a sku so that it can "see" the mail class and weight?
As an example - here is a sku 00-1007-133
The number 1007 tells us the mail class is First Class (1) and the weight is
7 ounces (7). How can I get excel to read just the 4 numbers in the center of
the sku?

Thanks so much for any help you can offer.

Thank you so very much for your help. I appreciate it more than words can say.

"sb1920alk" wrote:

If your sku is in A1, =MID(A1,4,4)

"snd679" wrote:

Our products have a sku number that contains information on the product
weight and mail class it is to ship by. How do I get excel to recognize just
that portion of a sku so that it can "see" the mail class and weight?
As an example - here is a sku 00-1007-133
The number 1007 tells us the mail class is First Class (1) and the weight is
7 ounces (7). How can I get excel to read just the 4 numbers in the center of
the sku?

Thanks so much for any help you can offer.