Search results for query: *

Phil and Ben Thanks. I opened up a new workbook first and them I opened up the old workbook and Ben's suggest has worked. This has saved me alot of time.

That is what I have been working on, I didn't want to destroy the original data. What ever characters are there get copied over each time.

I tried what Ben suggested. It doesn't like it either. I guess I will have to delete them manually. Thanks again. anna

Yes it was a straight copy and paste. I tried a paste special but the fields go all wonky.

It is excel 2000. I get the data for a web site. I copied the into a vb module, I think. I ran it out of the macros. As you can guess I am new at this. I am not sure if I am doing this right. I got an compile error. Invalid character.

Yes, I tried it with tab checked off, and then with tab checked off. The field still looks the same. anna

I have tried that too. the volumes vary in size so this doesn't work. It seems that the spaces are really not spaces or tabs. Here is an example of the data. 286.487   44.863   4000   1100   5500   500   14000   Thanks so much for this help. anna

I have tried that and the number is still the same.

I am trying to clean an excel field. I get the field from and html screen. The field is volume. It is coming across to excel with two spaces on the end. I have tried the function, find and replace but that doesn't work. I can't change the field to a number using format cell. Can anyone...