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.


--
b166er
------------------------------------------------------------------------
b166er's Profile: http://www.excelforum.com/member.php...o&userid=34912
View this thread: http://www.excelforum.com/showthread...hreadid=546524

wild card with if logical function
 

Check your *first* post.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"b166er" wrote in
message ...

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

wild card with if logical function
 

i would use a search or find to find the - and read the first two character
to the left.
--
paul

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" wrote in
message ...

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