Survey data from different excel files with slightly different answers

[Suedseeperle]

Dear Alteryx community,

I have data from a survey coming from two different excel files. For further editing I would like to make them the same. Can you help me please? The only difference are the two spaces in the middle...

[nagakavyasri]

@Suedseeperle You can use Cleansing tool or Formula tool to remove space: