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.