software

Calling all Geniuses,

Is it possible to trim down something like this, I have over 4 thousand of
these, they are SKU's with case pack size

9811HAC-6, I need it to be just 9811, I need it to strip the HAC-6
5465PAD-12, I need it to be just 5465, I need it to strip the PAD-12
and so on.

Regards,If it is always the first 4 characters, use this formula to return a text
representation of the #s.

=left(A1,4)

If you want Excel to view the results as numbers, use

=1*left(A1,4)

This assumes your SKU is in A1

quot;JavyDquot; wrote:

gt; Calling all Geniuses,
gt;
gt; Is it possible to trim down something like this, I have over 4 thousand of
gt; these, they are SKU's with case pack size
gt;
gt; 9811HAC-6, I need it to be just 9811, I need it to strip the HAC-6
gt; 5465PAD-12, I need it to be just 5465, I need it to strip the PAD-12
gt; and so on.
gt;
gt; Regards,
gt;

On Tue, 28 Mar 2006 06:19:47 -0800, JavyD gt;
wrote:

gt;Calling all Geniuses,
gt;
gt;Is it possible to trim down something like this, I have over 4 thousand of
gt;these, they are SKU's with case pack size
gt;
gt;9811HAC-6, I need it to be just 9811, I need it to strip the HAC-6
gt;5465PAD-12, I need it to be just 5465, I need it to strip the PAD-12
gt;and so on.
gt;
gt;Regards,If it is always the same number of digits:

=LEFT(A1,4)

If the number of digits may vary:=LEFT(A1,MATCH(FALSE,ISNUMBER(-MID(A1,ROW(INDIRECT(quot;1:8quot;)),1)),FALSE)-1)

entered as an **array** formula. After copying the formula, hold down
lt;ctrlgt;lt;shiftgt; while hitting lt;entergt;. Excel will place braces {...} around the
formula.

Note the number quot;8quot; in the formula above. This should be changed to reflect
the maximum number of digits that might be present in the SKU.--ron

Thanks Duke, but it's not always the first characters, it could be something
like 981165PPP-6, then I'll need 981165.

quot;Duke Careyquot; wrote:

gt; If it is always the first 4 characters, use this formula to return a text
gt; representation of the #s.
gt;
gt; =left(A1,4)
gt;
gt; If you want Excel to view the results as numbers, use
gt;
gt; =1*left(A1,4)
gt;
gt; This assumes your SKU is in A1
gt;
gt; quot;JavyDquot; wrote:
gt;
gt; gt; Calling all Geniuses,
gt; gt;
gt; gt; Is it possible to trim down something like this, I have over 4 thousand of
gt; gt; these, they are SKU's with case pack size
gt; gt;
gt; gt; 9811HAC-6, I need it to be just 9811, I need it to strip the HAC-6
gt; gt; 5465PAD-12, I need it to be just 5465, I need it to strip the PAD-12
gt; gt; and so on.
gt; gt;
gt; gt; Regards,
gt; gt;