replace space in string with non-space

I have a list of numbers in in column K. Example as follows:
12345678
12 6567893
65236688
533 5944
903 5234

I want to extract the first 5 characters, not including spaces. The code below is taking the first 5 characters and removing the spaces but it is counting the space as a character. For example...533 5944 returns a value of 5335. It should return a value of 53359. I tried putting the replace function in a different part of formula but can't get it working. Any assistance is appreciated. Thanks.

Please Login or Register  to view this content.

Hi Maac, try:

Please Login or Register  to view this content.

try

Please Login or Register  to view this content.