I think this should be easy but can't figure it out. I have a row with data and need to remove the blank spaces between the text. So for example, I have something that looks as follows:
Tim Smith
Frank Bruno
And need it to look like this:
TimSmith
FrankBruno
Is there a formula I can use to accomplish this? I tried =clean & =trim but neither worked
Tim Smith
Frank Bruno
And need it to look like this:
TimSmith
FrankBruno
Is there a formula I can use to accomplish this? I tried =clean & =trim but neither worked