SOS318 Eliminate Enter Spaces

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

Custom Tools

Accepted answers

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

Hope this helps : )

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

Hope this helps : )

Thanks buddy - unfortunately they dont work.