Solved can i clear a blank charactor from a downloaded name?

October 29, 2013 at 16:16:23
Specs: Windows 7
I have a situation where I down load data and delineate results leaving a name with blanks behind the number making a Vlookup difficult.

ASIAN HONDA MOTOR CO.,LTD.

The name above is an example. Is there a formula I can use to remove any blanks behind the last character?


See More: can i clear a blank charactor from a downloaded name?

Report •

#1
October 29, 2013 at 19:09:37
✔ Best Answer
There are programs that will remove blank spaces but I'm not sure if they are smart enough to remove the spaces from just behind the last character.

Have a look at this renaming program, I use it every now and then and has the ability to remove blank spaces.

http://www.softpedia.com/get/System...


Report •
Related Solutions


Ask Question