Extra Spaces with copied data

  • Thread starter Thread starter shane24
  • Start date Start date
S

shane24

I recently had to copy a large amount of data from my company's website.
When I copied it over to Excel all cells had trailing spaces, 5 spaces
to be exact.

What I need to know is how do I sweep through and get rid of all those
extra spaces. They are interferring with calculations and sorting of
numbers.

Thanks for all your help.
 
Try using function TRIM. It removes all extra spaces at the beginning
and at the end of cells, as well as between symbols, if spaces are more
than one.
 
If you have a constant 5 spaces in all cells, you are lucky because you can
replace them with an empty string:
Select all cells (click on the top left corner)
Edit/Replace, type five spaces into field Find and nothing in field Replace,
then click Replace All

Regards,
Stefi


„shane24†ezt írta:
 
Let me try to show you what I did and see what you think. I am usin
the quotes so it is easy to see the spaces that are actually in th
cell.

Cell A1 = "John Smith "

Using your suggestion of TRIM I did this

Cell B1 = TRIM(B1)

Then in C1 I used the paste special function to paste just the value o
the result of B1. I still got "John Smith " as the result.

Am I using TRIM wrong?
 
Thank you Stefi.

I tried that and Excel said it couldn't find the data I have searched
for.

Any other ideas please?

Thanks,
Shane
 
The blank spaces may not really be "spaces". They may be HTML
non-breaking spaces.

To remove them:
Edit>Replace
Find What: [alt]+0160 <-Hold down the [Alt] key..press 0160...release
[Alt]
Replace with: (leave this blank)
Click [Replace All]

Does that help?

Ron
 
Back
Top