I have a barcode (0022334455) in 1st cell and 2nd cell is a category IE "SNT".

I want to create a SKU by taking the last 5 digits (34455) from barcode and adding the category in front SNT

Required Result - SNT34455I would appreciate any tps as i have 15000 products to do

Cheers

You can either fix the category within the formula, if the category will always be constant ie "SNT" or reference the cell in which it is in. A B C 1 22334455 ="SNT" & RIGHT(A1,5) 2 33224446 BNT =B2 & RIGHT(A2,5)The formulas in C will have the following results

C1 will become SNT34455 and C2 will become BNT24446

message edited by AlwaysWillingToLearn

Ask Your Question

Weekly Poll