Removing Spaces within a cell

[Nairobi Nice]

Hi All

I want to adapt your code for my worksheet.

The data was run through SPSS so everything is merged eg "Fanta Strawberry 40 ml" is now "FantaStrawberry40ml"

What would be the code to merge everything in a cell? May even be just a function.

ie Current = "Fanta Strawberry 40 ml"
Expected = "FantaStrawberry40ml"

Thanks

[Bishonen]

Please Login or Register  to view this content.

strString is the string of a cell ofc.

for example

Please Login or Register  to view this content.

[thisisgerald]

@Nairobi

Can you attach a sample workbook?

You can use the function

Replace(string," ","")

[Nairobi Nice]

Many Thanks Bishonen

Works perfectly

@thisisgerald - thanks,