How to remove extra spaces in a cell

[Chris1973]

Hi there

I have about 7800 codes

Some of them have extra space between them, how do i remove the extra spaces

code should be like

00893 200 200

instead is it now like

00893 200 400

Is there a way to remove the extra space obly to 1 space between each. I know you can use the rim function but i dont come right

 

[Joe4]

Do you mean that you have two spaces in between some values and you want to trim it to one?
If so, simply do a Find Replace, and replace two spaces with one, and choose "Replace All".

 

[Fluff]

I know you can use the rim function but i dont come right

That suggests you might have non-breaking spaces of some sort.
Select the cells, Ctrl H, in "Find what" enter Alt 0160 (using the number keypad) & leave the replace box empty.
Then make sure that "Match entire cell" is unchecked & click replace all.

 

[Chris1973]

This is the problem, some have 2 spaces, some have 3 and some have 4.

Just want there to be one space between 00893 and 200 and 200

 

[Chris1973]

@Fluff
When i do this do i get the message there is nothing to replace, however it is there

 

[Joe4]

Did you try my solution?
Did that do anything?

If they are normal spaces, and 4 is maximum number of spaces you have between items, just do what I proposed three times, and it should take care of it.

 

[Chris1973]

Thanks, guys, got it right using the trim function.

Created a helper column, entered the code =Trim(a1)

Copied and paste and all extra spaces gone