Thread: Applying a simple formula for each cell in column?

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

Bolton,

You mean to say you want this formulae to work only if there is data in the columns, G B and K. if thats the case then use this function,

=if(or(g2="",b2="",k2=""),"",g2&"."&b2&"."&k2)

thats great, works a treat, thanks!

now to learn the IF and OR functions properly :-)