Extra space

B

Bob

I have an extra space at the end of a set of numbers in a
series of cells. I need to remove that extra space or
blank entry at the end of those numbers. Ex. 123456_
where the _ is the blank entry. Is there a way to do this?
 
J

JE McGimpsey

one way among many:

Select the cells, one column at a time and choose Data/Text to Columns.
Click Finish.
 
T

Tomás

This one is very easy.
Just select the data in a column with the cursor then go
to Edit in the Menu and pick Replace.
Enter a space at the Find what: and let the Replace with:
empty. (That will eliminate the space from any place
inside of the selected area).
Warning : If you have spaces between the numbers and you
need that space do not use this method. It will eliminate
all the spaces in the data and it will convert the
information in numbers unless it has any letter in the
fields.
 
Top