Thread: Can I find a string with or without a space after the last charact

I have a word in a Cell. I copy it in " Find". I Search in another Sheet that
word. If I have extra spaces before or after it I can not find it often it
exists. The word changed. I tried to write a macro but it doesn’t work. Can
helps me someone?
Thanks millions.
Emil

Try setting the Lookin value to xlPart in the Find statement.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"emil" <emil@discussions.microsoft.com> wrote in message
news:307B776A-5654-409C-A3E9-DA530145AC99@microsoft.com...
> I have a word in a Cell. I copy it in " Find". I Search in another Sheet
that
> word. If I have extra spaces before or after it I can not find it often it
> exists. The word changed. I tried to write a macro but it doesn't work.
Can
> helps me someone?
> Thanks millions.
> Emil
>

not a very high tech way but ......

the find command so long as the 'match entire contents' box is not ticked would not worry about the spaces.

eg if your cell you are copying is 'test ' on the other sheet if you search for 'test' it should find all instances regardless of spaces.

also you have the chance to use the TRIM command, as it will strip the spaces off the end of cells.

one thing to watch out for is if the second sheet you are looking on has the word as the result of a formula as sometimes it searches the formula code and not the results

Thank very much, but I want to write a macro

"Bob Phillips" a scris:

> Try setting the Lookin value to xlPart in the Find statement.
>
> --
>
> HTH
>
> Bob Phillips
>
> (replace xxxx in the email address with gmail if mailing direct)
>
> "emil" <emil@discussions.microsoft.com> wrote in message
> news:307B776A-5654-409C-A3E9-DA530145AC99@microsoft.com...
> > I have a word in a Cell. I copy it in " Find". I Search in another Sheet
> that
> > word. If I have extra spaces before or after it I can not find it often it
> > exists. The word changed. I tried to write a macro but it doesn't work.
> Can
> > helps me someone?
> > Thanks millions.
> > Emil
> >
>
>
>

Thank very mach, I shall try this
Emil

"lister_d_000169" a scris:

>
> not a very high tech way but ......
>
> the find command so long as the 'match entire contents' box is not
> ticked would not worry about the spaces.
>
> eg if your cell you are copying is 'test ' on the other sheet if you
> search for 'test' it should find all instances regardless of spaces.
>
> also you have the chance to use the TRIM command, as it will strip the
> spaces off the end of cells.
>
> one thing to watch out for is if the second sheet you are looking on
> has the word as the result of a formula as sometimes it searches the
> formula code and not the results
>
>
> --
> lister_d_000169
> ------------------------------------------------------------------------
> lister_d_000169's Profile: http://www.excelforum.com/member.php...o&userid=32950
> View this thread: http://www.excelforum.com/showthread...hreadid=548349
>
>

TRIM is very good
Thank very mach
Emil

"emil" a scris:

>
> Thank very mach, I shall try this
> Emil
>
> "lister_d_000169" a scris:
>
> >
> > not a very high tech way but ......
> >
> > the find command so long as the 'match entire contents' box is not
> > ticked would not worry about the spaces.
> >
> > eg if your cell you are copying is 'test ' on the other sheet if you
> > search for 'test' it should find all instances regardless of spaces.
> >
> > also you have the chance to use the TRIM command, as it will strip the
> > spaces off the end of cells.
> >
> > one thing to watch out for is if the second sheet you are looking on
> > has the word as the result of a formula as sometimes it searches the
> > formula code and not the results
> >
> >
> > --
> > lister_d_000169
> > ------------------------------------------------------------------------
> > lister_d_000169's Profile: http://www.excelforum.com/member.php...o&userid=32950
> > View this thread: http://www.excelforum.com/showthread...hreadid=548349
> >
> >