Hello,

I have to merge two datasets. The key variable is str32. The problem I'm facing is that in one of the data files, this key variable is like 'TUS10008106201911420902372MAN 01' and in another, it is like 'TUS10008106201911420902372MAN01'. Due to this, around 8,000 observations are not matching. Is there any way to remove the spaces in one go because doing it manually will consume a lot of time?

Thanks.