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.


"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
>

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? 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,

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? 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
> > >

> 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.

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
<(E-Mail Removed)> 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