Extra space

  • Thread starter Thread starter Bob
  • Start date Start date
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?
 
one way among many:

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

Select an empty cell
Copy
Select the rogue cells
Edit > Paste Special
Check "Add"
OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
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.
 
Back
Top