VBA concatenate script does not excute as expected, Concatenate and "&" can't be dragged

Hi,
1. We have a file with battery serial and manufacture numbers from our Chinese manufacturer.
2. For the account program in Hamburg we require the text from column C- and E cells to be concatenated.
EGRET SERIAL NUMBER PO8.6 2nd.xlsx

Cells in column C and E already contain "&" formulae from columns B and D.

Concatenate for requirement 2 above only works for the first instance, eg. F1 =CONCATENATE(C1,E1) gives the right cell content, however

when dragging this down then F2 =CONCATENATE(C2,E2)
gives the same value as F1 and doesn't concatenate C2 with E2 at all.
Using "&" exhibits the same problem.

I have tried the MS support forum for a VB script: http://support.microsoft.com/kb/213477

This also doesn't produce the desired result- it ignores contents from column C and only adds column B, (eg C1="txt"&B1 -ignores the "txt" and adds B1)
yet for column E it adds its value and the &D column. (column E format is same as C column eg E1= "txt"&D1)

Tried changing the formatting from text to general, again no luck.

As this will be a monthly event, any solutions would be greatly appreciated, never seen anything like this before.