MERGE 3 columns into 1 all text

  • Thread starter Thread starter Suzie
  • Start date Start date
S

Suzie

I found your forum and hope you can help.

I have a product spreadsheet that my IT guy just informed me that I
need to combine 3 different columns into one, I have tried the &" "&
approach for all the data, but I keep getting a circular error. Each
column is about 150 rows. All the columns/rows contain text and not
numeric value.

Thanks for any help.
 
Suzie said:
I found your forum and hope you can help.

I have a product spreadsheet that my IT guy just informed me that I
need to combine 3 different columns into one, I have tried the &" "&
approach for all the data, but I keep getting a circular error. Each
column is about 150 rows. All the columns/rows contain text and not
numeric value.

Thanks for any help.
Click to expand...

Without specific column references to work with, an exact answer cannot be
provided. However, it would appear that you are trying to enter your formula in
one of the 3 columns you need to combine. You should enter the formula in an
empty column. So for example, if the three columns that need to be combined are
C, D and G, put the following in Z1 (assuming there is nothing in column Z):

=C1&" "&D1&" "&G1

Copy that down as far as necessary. If you want the result as text in column C,
select column Z and Edit / Copy. Select column C and Edit / Paste Special /
Values. Then delete columns Z, G and D.
 
Assuming your data is in columns A-C. In cell D1:
=A1&" "&B1&" "&C1
Copy this down as needed.

Now, copy the entire column with your newly created formulas. Right-click,
paste special. Select "values only". Your combined values have now become
static, and you can remove/delete columns A-C.
 
Back
Top