Hi all, can anyone be so kind to assit with the following problem.
I'm trying to combine two columns, A & B.
Column A has first name and column B has the last name.
I read a few other post indicating how this can be done, but my questions is
how to apply the equation to the entire spreadsheet.
=A1&' 'B1 work perfect but only for the first line. Again how do I use this
format for line 2 and downwards to get the outcome instead of doin each line
at a time.
Many thanks for everyones help.
Regards.

Just copy the formula and then select the region you want the formula to be
in and just paste it.

"R.S." wrote:

Hi all, can anyone be so kind to assit with the following problem.
I'm trying to combine two columns, A & B.
Column A has first name and column B has the last name.
I read a few other post indicating how this can be done, but my questions is
how to apply the equation to the entire spreadsheet.
=A1&' 'B1 work perfect but only for the first line. Again how do I use this
format for line 2 and downwards to get the outcome instead of doin each line
at a time.
Many thanks for everyones help.
Regards.

Thanks for your help.
I tried the formula and again it works for the first line only.
I must not be doing it correctly. Could you explain in detail or in a
simple manner to apply this formula for the rest of the spreasheet. Thanks
for your time and assitance.
Regards, r.s.

"akphidelt" wrote:

Just copy the formula and then select the region you want the formula to be
in and just paste it.

"R.S." wrote:

Hi all, can anyone be so kind to assit with the following problem.
I'm trying to combine two columns, A & B.
Column A has first name and column B has the last name.
I read a few other post indicating how this can be done, but my questions is
how to apply the equation to the entire spreadsheet.
=A1&' 'B1 work perfect but only for the first line. Again how do I use this
format for line 2 and downwards to get the outcome instead of doin each line
at a time.
Many thanks for everyones help.
Regards.

oK, I tried it again and it worked perfect this time.
thank you.

"akphidelt" wrote:

Just copy the formula and then select the region you want the formula to be
in and just paste it.

"R.S." wrote:

Hi all, can anyone be so kind to assit with the following problem.
I'm trying to combine two columns, A & B.
Column A has first name and column B has the last name.
I read a few other post indicating how this can be done, but my questions is
how to apply the equation to the entire spreadsheet.
=A1&' 'B1 work perfect but only for the first line. Again how do I use this
format for line 2 and downwards to get the outcome instead of doin each line
at a time.
Many thanks for everyones help.
Regards.