SOS318 Eliminate Enter Spaces

[alansuarez]

Hi Guys - trying to eliminate the enter spaces from my data.

Input:

My name is Alan. 

I am trying to eliminate enter spaces.

Output:

My name is Alan. I am trying to eliminate enter spaces.

PLEASE HELP!

Alan

[alansuarez]

Hi Guys - trying to eliminate the enter spaces from my data.

Input:

My name is Alan. 

I am trying to eliminate enter spaces.

Output:

My name is Alan. I am trying to eliminate enter spaces.

PLEASE HELP!

Alan

[atcodedog05 · Accepted solution]

Hi @alansuarez 

The easiest way is to use data cleanse tool. You can also use formula tool.

Hope this helps : )

[alansuarez]

Thanks buddy - unfortunately they dont work. 

[atcodedog05]

Hi @alansuarez 

Hmm interesting why not. Can you provide sample data in a file where you are facing the issue?