Remove all spaces between words

[Melf72]

I have a large list of Suburbs, postcodes and State. The postcodes in column A, suburbs in column B and the state in column C. I need to generate a unique code for each suburb and it can only be 4 digits. I would like to use the first number in the postcode as the first digit and 3 letters from the suburb name to make up the last 3 digits. Is there a way l can get Excel to generate the code? I will also need to remove any spaces in the text as some suburbs are more than one word. Is there a function that will remove all spaces from between words. I have looked at the Trim function but it only removes spaces after.

I have attached an example of my data.