| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy & paste spreadsheet cells from excel to outlook to excel | Excel Discussion (Misc queries) | |||
| Use functions when cells are merged | Excel Worksheet Functions | |||
| Fill cells from non-adjacent cells | Excel Discussion (Misc queries) | |||
| Help adding text values | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Threaded Mode
