Merging text columns

  • Thread starter Thread starter RyanR8881
  • Start date Start date
R

RyanR8881

My work sheet looks like this:

4616 l STOKES l ST
2844 l OAKDALE l ST
2919 l KING COLE l DR
3504 l COLONIAL l AVE
3218 l SUNNYVALE l ST
2837 l OAKDALE l ST
3714 l SUNNYVALE l ST

I want to merge to be like this "4616 STOKES ST". Whats the easiest way to
do this?
 
=A1&" "&B1&" "&C1
or
=CONCATENATE(A1," ",B1," ",C1)

Hope this helps.
 
You must log in or register to reply here.

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

Similar Threads

Formula function(s) to do this? Or is it a formula at all? 4
Help with merged cells 1
pulling select names by codes? 1
counting frequency of text string 3
Add If formula in macro (replace cell text value with numeric valu 1
sum and count text and numbers same column 1
problem with find in merged cells 10
Excel A CountIF question... I think 2

Back
Top