how to combine /merge two field to one field

[Guest]

I have column a and column , how to combine two fields to one field.

Column a name client 1, column B name client 2,

I want to combine column 1 & column 2 to one column.


Please help.

 

[Guest]

In a cell in a third column insert:-

=A1 & B1

If you want a space between the names then:-

=A1 & " " & B1

Copy the formula down for the length of the data.

If you then want to remove the formulas and delete the columns containing
the initial data, You can Select the column with the formulas,
copy->paste special->values over top of itself.

Regards,

OssieMac

 

[Guest]

Thanks, you are great.

In a cell in a third column insert:-

=A1 & B1

If you want a space between the names then:-

=A1 & " " & B1

Copy the formula down for the length of the data.

If you then want to remove the formulas and delete the columns containing
the initial data, You can Select the column with the formulas,
copy->paste special->values over top of itself.

Regards,

OssieMac