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