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