Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MERGE 3 columns into 1 all text
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MERGE 3 columns into 1 all text
You'll get a circular error if you try to use one of the input cells as the
destination of your formula. If your formula is =A1&" "&B1&" "&C1, don't put the formula in A1 or B1 or C1. Put it in D1, for example. -- David Biddulph "Suzie" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MERGE 3 columns into 1 all text
Suzie wrote:
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. 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MERGE 3 columns into 1 all text
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. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Suzie" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge Columns | Excel Discussion (Misc queries) | |||
text outside merge cells despite clicking wrap text | Excel Worksheet Functions | |||
merge columns | New Users to Excel | |||
How can I merge two columns containing text in excel? | Excel Discussion (Misc queries) | |||
merge text from 2 columns into 1 then delete the old 2 columns | Excel Worksheet Functions |