Remove all spaces between words

Melf 72
You say you want to create a unique code for each suburb, I would of thought you already have that within the post code.
If you use the first digit from the post code and the first three letters from the suberb, I think it will create a major headache for you because within the short list you have supplied there is 6280 ABBA RIVER (6ABB) and there is 6280 ABBEY (6ABB) or are these two places the same place?
Regards
Peter
Looking through the phone book there are countless examples were the above procedure will create duplicate codes,
BEVERLRY PARK 2217 (2BEV)
BEVERLEY HILLS 2209 (2BEV)
CABRAMATTA 2166 (2CAB),
CABRAMURRA 2629 (2CAB)
Regards
Peter

If you combined the complete post code and complete suberb name, this would give an unique code but this may be to long in some cases, CABRAMATTA 2166, 2166CABRAMATTA
CABRAMURRA 2629 (2629CABRAMURRA), in which case all you have to do is use MArvinP's solution ,or highlight the column, Ctrl F and use the replace tab, in the top " ", in the bottom "".
Regards
Peter
Sorry in the example you have supplied use =SUBSTITUTE((A2&B2)," ","")
REGARDS
Peter

hello again
Or this
If you want it in alpha-numerical order then instead of a2&b2&c2 ,use b2&a2&c2