Prev: How do I set up more than 3 conditional formatting?
Next: Delete rows that don't contain...
From: senthil on 19 May 2010 06:09
i have a data address data in 3 columns like door no. in one, street no in
another & city name in another column. shall i get all these address in a
single column (consolidated)

Thanks
From: Pritesh on 19 May 2010 06:27
Try below formula...

If data is in columns A, B & C... then in column D, say...

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

Here, & works as concatinator/joiner and " " puts space. You can ignore " "
or try putting any other thing there like "-".

--
Regards,
Pritesh


"senthil" wrote:

> i have a data address data in 3 columns like door no. in one, street no in
> another & city name in another column. shall i get all these address in a
> single column (consolidated)
>
> Thanks
From: Jacob Skaria on 19 May 2010 06:49
Try the below and enable Wrap Text from Format>Cells>Alignment>Text control

=A1&CHAR(10)&B1&CHAR(10)&C1

--
Jacob (MVP - Excel)


"senthil" wrote:

> i have a data address data in 3 columns like door no. in one, street no in
> another & city name in another column. shall i get all these address in a
> single column (consolidated)
>
> Thanks
From: Gord Dibben on 19 May 2010 14:40
See other replies for suggestions on how to do.

My suggestion is...........don't do it.

Makes it much more difficult if in the furture you wish to sort or filter
the data.


Gord Dibben MS Excel MVP

On Wed, 19 May 2010 03:09:01 -0700, senthil
<senthil(a)discussions.microsoft.com> wrote:

>i have a data address data in 3 columns like door no. in one, street no in
>another & city name in another column. shall i get all these address in a
>single column (consolidated)
>
>Thanks

 | 
Pages: 1
Prev: How do I set up more than 3 conditional formatting?
Next: Delete rows that don't contain...