Extra space after imported numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am importing reports from a website. All the numbers come with a space
after the last number, so it is not recognised as a number by excel. what is
the easiest way to remove this space so I can work with the numbers?

eg. 6502<space> (it is one space, and always to the right of the number)
 
select the column that has the values
Press Ctrl H
Find what (Press ALt key and simultaneoulsly type 0160 )
replace with (leave this blank)
replace all

This will remove the trailing spaces that sometimes do not go away by using
the value & trim functions
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to convert a number with spaces to just a number? 10
Format number 2
Removal of 100's of spacing in numbers 4
Excel Subtract text after the third space and before the fourth (from between spaces) 3
format to a specific number of spaces 2
long number ends in 000 2
Letter and space count in cell 1
Numbers followed by space 4

Back
Top