Norman Jones Wrote:
Hi M,

If the exclamation character (!) is found, both expressions work for
me.

InStr gives result 6 but I need value 5 for function left.
What am I doing wrong? or what can I do wrong?!?


--
mpele
------------------------------------------------------------------------
mpele's Profile: http://www.excelforum.com/member.php...o&userid=31808
View this thread: http://www.excelforum.com/showthread...hreadid=520041