| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine multiple columns
Hello,
Is it possible to combine multiple columns of info into a single column? Im working with Excel 2003. Example: column A- 4. Column B- After term. Column C- charges after term date. Column D- charges not covered. I need it to look similar to this: 4 -After term -charges after term date-charges not covered |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combine multiple columns
Hi Nichole,
Presuming everything is in row 1. Try =A1&B1&C1&D1 -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "Nichole" wrote: Hello, Is it possible to combine multiple columns of info into a single column? Im working with Excel 2003. Example: column A- 4. Column B- After term. Column C- charges after term date. Column D- charges not covered. I need it to look similar to this: 4 -After term -charges after term date-charges not covered |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combine multiple columns
Hello Warren,
Thank you for your help! I'm still very new at Excel can you please elaborate on your answer. Thanks for your patients. "Warren Easton" wrote: Hi Nichole, Presuming everything is in row 1. Try =A1&B1&C1&D1 -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "Nichole" wrote: Hello, Is it possible to combine multiple columns of info into a single column? Im working with Excel 2003. Example: column A- 4. Column B- After term. Column C- charges after term date. Column D- charges not covered. I need it to look similar to this: 4 -After term -charges after term date-charges not covered |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combine multiple columns
Hi,
If you type =A1&B1&C1&D1 into cell E1 this might get you started on what your looking for. -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "Nichole" wrote: Hello Warren, Thank you for your help! I'm still very new at Excel can you please elaborate on your answer. Thanks for your patients. "Warren Easton" wrote: Hi Nichole, Presuming everything is in row 1. Try =A1&B1&C1&D1 -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "Nichole" wrote: Hello, Is it possible to combine multiple columns of info into a single column? Im working with Excel 2003. Example: column A- 4. Column B- After term. Column C- charges after term date. Column D- charges not covered. I need it to look similar to this: 4 -After term -charges after term date-charges not covered |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combine multiple columns
Is it possible to combine multiple columns of info into a single
column? I’m working with Excel 2003. Example: column A- 4. Column B- After term. Column C- charges after term date. Column D- charges not covered. I need it to look similar to this: 4 -After term -charges after term date-charges not covered One way is to put this in E1 and copy down as far as needed: =TRIM(A1&" "&B1&" "&C1&" "&D1) Put in extra punctuation as needed. Columns A:D can be hidden if needed. The "&" concatenates text strings. The TRIM function gets rid of extra spaces. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combine multiple columns
Are the dashes already in place?
=A1 & " " & B1 & " " & C1 & " " & D1 If not............... =A1 & " -" & B1 & " -" & C1 & " -" & D1 Adjust to suit. Gord Dibben MS Excel MVP On Mon, 1 Dec 2008 12:53:00 -0800, Nichole wrote: Hello, Is it possible to combine multiple columns of info into a single column? I’m working with Excel 2003. Example: column A- 4. Column B- After term. Column C- charges after term date. Column D- charges not covered. I need it to look similar to this: 4 -After term -charges after term date-charges not covered |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I combine multiple columns of data into 1 column? | New Users to Excel | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| How do I combine multiple columns into just 1 column? | Excel Discussion (Misc queries) | |||
| How do I combine multiple whooksheets with identical columns | Excel Worksheet Functions | |||
Linear Mode
