I have a big sheet of imported names and zip codes that I want to sort.
Some of the names have been split across two cells, one part beneath the other. The second part of the name has a blank zip code cell beside it.
I want to test for this blank cell and, if present, concatenate the two parts of the name and store it in a new cell.
I just can't get my head around the syntax - could anyone give me a pointer please?