Remove data in a cell

[sjs]

I have a column of data where some of the data ends in ' 1' (space 1). How
do I remove the (space 1)?

For example:
test
trial 1

I need:
test
trial

tks,
steve

 

[Gord Dibben]

Select the column.

Edit>Replace

What: space*

With: nothing

Replace all.


Gord Dibben MS Excel MVP

 

[sjs]

Jeez, sometimes I'm so dumb...Thanks Gord!

Select the column.

Edit>Replace

What: space*

With: nothing

Replace all.


Gord Dibben MS Excel MVP