Combine cells
I have a sheet that has 3 cells that I would like to make one. Cell G,H, and I The cells are for an address. They are the street #, street and Unit number. So some times the cells are null. Any help would be great. Keith |
you could use the function called "concatnate"
"KAnoe" wrote: I have a sheet that has 3 cells that I would like to make one. Cell G,H, and I The cells are for an address. They are the street #, street and Unit number. So some times the cells are null. Any help would be great. Keith |
its CONCATENATE...i spelled it wrong b4
"nick" wrote: you could use the function called "concatnate" "KAnoe" wrote: I have a sheet that has 3 cells that I would like to make one. Cell G,H, and I The cells are for an address. They are the street #, street and Unit number. So some times the cells are null. Any help would be great. Keith |
Hi
In Cell J1 =G1&" "&H1&" "&I1 If you want commas between the items, then put a comma between the quotes in the formula e.g. ", " Regards Roger Govier KAnoe wrote: I have a sheet that has 3 cells that I would like to make one. Cell G,H, and I The cells are for an address. They are the street #, street and Unit number. So some times the cells are null. Any help would be great. Keith |
Simple version
=g1&" "&h1&" "i1 Version to account for Nulls =g1&rept(" ",len(trim(g1))0)&h1&rept(" ",len(trim(h1))0)&i1 "KAnoe" wrote: I have a sheet that has 3 cells that I would like to make one. Cell G,H, and I The cells are for an address. They are the street #, street and Unit number. So some times the cells are null. Any help would be great. Keith |
All times are GMT +1. The time now is 11:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com