Excel 2003: I have a column that looks that has values in it like this:
I need to reduce the column to just plain numbers no % no text, I have a program that does this but it is thrid party add-in and can't be used in a macro. I tried find and replace but that does not help as there are spaces and the spaces are not the same or in the same place. There is also for some reason special characters the / pops up in 5 different cells. I am trying to make this column so that I can sort it.
Please Login or Register to view this content.