Will you always have a numerical part in the middle followed by one or
two characters?

Pete

On Feb 12, 7:18 pm, jmcclain
wrote:
Dear Pete -

Another caveat - the actual item codes can be either 5 or 6 characters, such
as FL3990 or FL910 followed by either a 1 or 2 character color code such as
"RB" or "B".

Any ideas?



"Pete_UK" wrote:
If your codes are all of the same format, i.e. with a single letter at
the end, then you could add this formula in a helper column:

=LEFT(A2,LEN(A2)-1)

and copy down, assuming your item codes are in column A. Then use this
helper column to determine the change (and therefore where the
subtotal appears), rather than the item code.

Hope this helps.

Pete

On Feb 12, 4:57 pm, jmcclain
wrote:
I am trying to insert subtotals in a spreadsheet at each change of "item code"

However, the item codes are shown as "FL3909B", but I need to insert the
subtotal at each change in the core item #, that being "FL3909".

Can anyone tell me if it's possible and how to do it?

With Regards,

Jon- Hide quoted text -

- Show quoted text -