remove trailing spaces

I have imported a file that has an undetermined number of spaces after a text
entry. I need to strip those spaces out so my Vlookup will work. Really
appreciate any help.

Example
Cell A1 - contents Z01000 (plus 3 blanks) need to have just Z01000.

Hi

Try a helper column with
=TRIM(A1)
in it.

Hope this helps.
Andy.

"les8" <[email protected]> wrote in message
news:[email protected]...
>I have imported a file that has an undetermined number of spaces after a
>text
> entry. I need to strip those spaces out so my Vlookup will work. Really
> appreciate any help.
>
> Example
> Cell A1 - contents Z01000 (plus 3 blanks) need to have just Z01000.

Thank you very much. It worked and I am back in business.


"Andy" wrote:

> Hi
>
> Try a helper column with
> =TRIM(A1)
> in it.
>
> Hope this helps.
> Andy.
>
> "les8" <[email protected]> wrote in message
> news:[email protected]...
> >I have imported a file that has an undetermined number of spaces after a
> >text
> > entry. I need to strip those spaces out so my Vlookup will work. Really
> > appreciate any help.
> >
> > Example
> > Cell A1 - contents Z01000 (plus 3 blanks) need to have just Z01000.
>
>
>

You can use Find and Replace. Put a space in find and nothing in replace.

"les8" wrote:

> I have imported a file that has an undetermined number of spaces after a text
> entry. I need to strip those spaces out so my Vlookup will work. Really
> appreciate any help.
>
> Example
> Cell A1 - contents Z01000 (plus 3 blanks) need to have just Z01000.

Appreciate your suggestion. Thanks.

"Sloth" wrote:

> You can use Find and Replace. Put a space in find and nothing in replace.
>
> "les8" wrote:
>
> > I have imported a file that has an undetermined number of spaces after a text
> > entry. I need to strip those spaces out so my Vlookup will work. Really
> > appreciate any help.
> >
> > Example
> > Cell A1 - contents Z01000 (plus 3 blanks) need to have just Z01000.