Help with a continuing pattern

[jackowilkinson]

Hi All,

I am trying to get excel to continue a pattern in product description, by increasing the number by 1 each time. I can't seem to make it work using the drag down method. Does anyone have any formula suggestions to complete the Product Description field? I wouldn't ask if I didn't have several thousand of these to work through!

Many thanks

Jack

SKU	Product Description	Price	Category	Supplier	Weight (kg)
LUK1-1	Sprogs & Dogs 1 kg	6.40	Sprogs & Dogs		1
LUK1-2	Sprogs & Dogs 2 kg	12.80			2
LUK1-3	Sprogs & Dogs 3 kg	19.20			3
LUK1-4	Sprogs & Dogs 4 kg	25.60			4
LUK1-5	Sprogs & Dogs 5 kg	32.00			5
LUK1-6	Sprogs & Dogs 6 kg	38.40			6
LUK1-7	Sprogs & Dogs 7 kg	44.80			7
LUK1-8		51.20			8
LUK1-9		57.60			9
LUK1-10		64.00			10
LUK1-11		70.40			11
LUK1-12		76.80			12
LUK1-13		83.20			13
LUK1-14		89.60			14
LUK1-15		96.00			15
LUK1-16		102.40			16
LUK1-17		108.80			17
LUK1-18		115.20			18
LUK1-19		121.60			19
LUK1-20		128.00			20
LUK1-21		134.40			21
LUK1-22		140.80			22
LUK1-23		147.20			23
LUK1-24		153.60			24
LUK1-25		160.00			25

<tbody>
</tbody>

 

[gaz_chops]

Maybe

="Sprogs & Dogs "&F2&" kg"

 

[Mike LH]

Hi,

Assuming that the SKU is in Col A, put this in B2 and drag down

="Sprogs & Dogs " &TRIM(RIGHT(SUBSTITUTE(A2,"-",REPT(" ",256)),256)) &" kg"

 

[jackowilkinson]

Thank you folks, worked a treat!

Much appreciated

 

[gaz_chops]

You're welcome.