Hi all, first post from an excel newbie using excel 2007. Really hope someone can help as I know this is very simple...

ok, I have a sheet that is to be populated and I want the contents of rows G2, B2 and K2 to automatically appear in one column with full stops seperating them

So the formula for that column:

=G2&"."&B2&"."&K2


This works fine but my problem is applying it for all the cells below it in the column (simply dragging the formula down the column means I have a column of full stops and I cant have this as the data is to be converted to XML)

Any ideas?

Thanks in advance folks