Removing blank space between text in cell

[levanoj]

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

 

[Domski]

Have a look at Substitute or you could just do a Find...Replace.

Dom

 

[prabby25101981]

Try using this -

=SUBSTITUTE(A2," ","")

A2 is where you have the text.

 

[jc.021286]

Simple way,

select the column,
hit Ctrl+F

Find " " --> just the space bar, no quotations
Replace --> leave blank,

Replace all

Now you are done,
jc

 

[levanoj]

I knew it was something simple like that, thanks all.