i want to combine 2 cells with 1 cell only being partial

September 11, 2017 at 05:33:16
Specs: Windows 8
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 - SNT34455

I would appreciate any tps as i have 15000 products to do

Cheers


See More: i want to combine 2 cells with 1 cell only being partial

Reply ↓  Report •

#1
September 11, 2017 at 06:57:15
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


Reply ↓  Report •

#2
September 12, 2017 at 01:10:05
awesome....
thank you so much you have saved me a lot of work


Reply ↓  Report •

#3
September 12, 2017 at 01:20:20
No worries glad it helped. Thanks for letting us know.

Reply ↓  Report •
Related Solutions


Ask Question