wild card with if logical function

HI MEMBERS,

I need help to use if function with wild card. i want to get the value of 40(5th character) out of 32/2540-25 if i used wild card(?/*) with logical test eg

A1=32/??40* it shows invalid argument.

32/2540-25 is our cost job number and 40 character is for loacation.

32/2520-25 is our cost job number and 20 character is for loacation.
how can i use wild card with if logical function.

Check your *first* post.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"b166er" <b166er.28l52n_1148933404.2176@excelforum-nospam.com> wrote in
message news:b166er.28l52n_1148933404.2176@excelforum-nospam.com...
>
> HI MEMBERS,
>
> I need help to use if function with wild card. i want to get the value
> of 40(5th character) out of 32/2540-25 if i used wild card(?/*) with
> logical test eg
>
> A1=32/??40* it shows invalid argument.
>
> 32/2540-25 is our cost job number and 40 character is for loacation.
>
> 32/2520-25 is our cost job number and 20 character is for loacation.
> how can i use wild card with if logical function.
>
>
> --
> b166er
> ------------------------------------------------------------------------
> b166er's Profile:
http://www.excelforum.com/member.php...o&userid=34912
> View this thread: http://www.excelforum.com/showthread...hreadid=546524
>

i would use a search or find to find the - and read the first two character
to the left.
--
paul
paul.shepherd@nospamparadise.net.nz
remove nospam for email addy!



"Ragdyer" wrote:

> Check your *first* post.
> --
> Regards,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "b166er" <b166er.28l52n_1148933404.2176@excelforum-nospam.com> wrote in
> message news:b166er.28l52n_1148933404.2176@excelforum-nospam.com...
> >
> > HI MEMBERS,
> >
> > I need help to use if function with wild card. i want to get the value
> > of 40(5th character) out of 32/2540-25 if i used wild card(?/*) with
> > logical test eg
> >
> > A1=32/??40* it shows invalid argument.
> >
> > 32/2540-25 is our cost job number and 40 character is for loacation.
> >
> > 32/2520-25 is our cost job number and 20 character is for loacation.
> > how can i use wild card with if logical function.
> >
> >
> > --
> > b166er
> > ------------------------------------------------------------------------
> > b166er's Profile:
> http://www.excelforum.com/member.php...o&userid=34912
> > View this thread: http://www.excelforum.com/showthread...hreadid=546524
> >
>
>