Combine multiple columns

  • Thread starter Thread starter Nichole
  • Start date Start date
N

Nichole

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
 
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.
 
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.
 
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.
 
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
Click to expand...

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.
 
Are the dashes already in place?

=A1 & " " & B1 & " " & C1 & " " & D1

If not...............

=A1 & " -" & B1 & " -" & C1 & " -" & D1

Adjust to suit.


Gord Dibben MS Excel MVP
 
Back
Top