how do i merge the datas in 2 columns

S

senthil

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
 
P

Pritesh

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

Jacob Skaria

Try the below and enable Wrap Text from Format>Cells>Alignment>Text control

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

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top