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

awesome....

thank you so much you have saved me a lot of work

No worries glad it helped. Thanks for letting us know.

Ask Your Question

Weekly Poll

Do you think Intel should make discrete graphics cards?

Discuss in The Lounge

Poll History