Thread: left()
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mpele[_2_] mpele[_2_] is offline
external usenet poster
 
Posts: 1
Default left()


Why the command

b=Left(poz, InStr(poz, "!") + 1)

is working and

b=Left(poz, InStr(poz, "!") - 1)

doesn't work? It say: Invalid procedure call or argument...


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