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

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

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

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

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.

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