I have a worksheet in Excel 2002 made from a database. I have tried two
methods to combine data from several cells in a row into a separate cell as
below:

=(AL2&AM2&AN2&AO2&AP2&AQ2&AR2&AS2&AT2)
=CONCATENATE(AL3,AM3,AN3,AO3,AP3,AQ3,AR3,AS3,AT3)

Each of these functions are in cells AK2 and AK3 respectively. My problem is
in three parts:
1. Have I used these functions correctly to combine the data?
2. How do I get cells AK2 and/or AK3 to "equal" or display the result of the
function? (I have consulted several help resources and used the CTRL+` and
the Tools-Formula Auditing method but I only see the function, not the result)
3. How do I "fill" row AK2 thru AK309 with one of these formulas to combine
data from cells in adjacent columns as above?
Thanks