Excel - Help a Spreadsheet Numpty

[Plotloss]

Got two cells

In column A there is a static piece of text 'RUS-' in every row

In column B there is an individual product code in each row

In column C is a concat formula =$a$1&$b$1 which on row 1 produces the result RUS-R1250MC which is all good.

How though do I copy the formula so it increments the 1 to a 2 so the next row produces RUS-R850MC from RUS- and R850MC

Its driving me mad, is it 123 that has fill by example? Excel must have something similar but I cant bloody work it out.

[dougc]

Its to do with the positionning of the $. You need:

=$a1&$b1

then drag down to fill the cells below.

[Plotloss]

Worked like a dream, thanks mate.

Edited by Plotloss on Tuesday 3rd April 12:18

[tigger1]

dougc said:

Its to do with the positionning of the $. You need:

=$a1&$b1

then drag down to fill the cells below.

The $ symbol indicates that if you drag that formula, that part of it should remain the same - so you were effectively putting exactly the same formula down column C. By removing (as per the instructions) one of them, you tell it to concatenate the relevant row from column A and column B.

You could actually remove the $ symbols completely in this case.