how to combine /merge two field to one field

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Thanks, you are great.


OssieMac said:
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
Click to expand...
 
Back
Top