Combine multiple columns

[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

 

[Warren Easton]

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]

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]

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.

 

[MyVeryOwnSelf]

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 can be hidden if needed.

The "&" concatenates text strings. The TRIM function gets rid of extra
spaces.

 

[Gord Dibben]

Are the dashes already in place?

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

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

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

Adjust to suit.


Gord Dibben MS Excel MVP