Excel problem

J

JE McGimpsey

Forgot to say, if this is a one-off problem, put something like this in
an empty column:

=A1 & B1 & C1

or

=A1 & " " & B1 & " " & C1

Copy down as far as required. Copy the column. Select the first column
("A", above), and choose Edit/Paste Special, selecting the Values radio
button.
 
Top