merging cell without losing contents

  • Thread starter Thread starter Aaron
  • Start date Start date
A

Aaron

Add a column to the right of these three.

select a cell in that column and type:
=concatenate([click on street no cell or type cell
location], " ", [click on name cell], " ", [click on type
cell])

it should look something like this:
=concatenate(a2, " ", b2, " ", c2)
 
Thanks Aaron. It works great... If I may, I have one more
question. I have a list with several thousand fields. I
created a macro to do the concatenae... but I have to go
through each and every one to do it this way. Is there a
way to get it to automaticall do a concatrate on all the
fields at once?

Thanks again.
-----Original Message-----
Add a column to the right of these three.

select a cell in that column and type:
=concatenate([click on street no cell or type cell
location], " ", [click on name cell], " ", [click on type
cell])

it should look something like this:
=concatenate(a2, " ", b2, " ", c2)

-----Original Message-----
I have a sheet that has three fields for the address. It
has street No., street name, and street type. Example:

Street No Street Name Street type
1234 Main St.


I need to merge the address into one field like "address"
so that I can use it. When I try the "merge cells"
command, It only keeps the left-most value in the three
cells and doesnt merge the other 2 into it. It would be
impractical to do it by hand as there are several
thousand addresses on the list.

Is there any way to do this?

Thank You.
.
Click to expand...
.
Click to expand...
 
Did you put that formula in D2?

If yes and you want to do the same thing for 1000's of more rows, you could
select D2:D19999 (adjust as necessary).

Hit F2 (you'll be editing cell D2)
then hit ctrl-Enter.

Or you could use the autofill button (bottom right corner of the selected cell)
and drag it down the rows.

And a tip: Don't get rid of columns A:C. If something changes, fix it in one
of those cells and the formula will reevaluate. If it's too much clutter, hide
those columns. (It'll be a lot more difficult to separate those values back to
the component pieces.)
Thanks Aaron. It works great... If I may, I have one more
question. I have a list with several thousand fields. I
created a macro to do the concatenae... but I have to go
through each and every one to do it this way. Is there a
way to get it to automaticall do a concatrate on all the
fields at once?

Thanks again.
-----Original Message-----
Add a column to the right of these three.

select a cell in that column and type:
=concatenate([click on street no cell or type cell
location], " ", [click on name cell], " ", [click on type
cell])

it should look something like this:
=concatenate(a2, " ", b2, " ", c2)

-----Original Message-----
I have a sheet that has three fields for the address. It
has street No., street name, and street type. Example:

Street No Street Name Street type
1234 Main St.


I need to merge the address into one field like "address"
so that I can use it. When I try the "merge cells"
command, It only keeps the left-most value in the three
cells and doesnt merge the other 2 into it. It would be
impractical to do it by hand as there are several
thousand addresses on the list.

Is there any way to do this?

Thank You.
.
Click to expand...
.
Click to expand...
Click to expand...
 
Back
Top