Thanks for very much, that was just what I was looking for.
Best Regards
Dave
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Prabhu Pinky
Sent: Tuesday, October 29, 2013 6:18 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ data
You can use =trim() formula to remove the blanks in end of the word or
starting of the word.
On 30-Oct-2013 4:37 AM, "Pehrson, Dave" wrote:
> I have a situation where I down load data and delineate results leaving
> a name with blanks behind the number making a Vlookup difficult.
>
> ** **
>
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?
Your help as always is
