View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
mphell0
 
Posts: n/a
Default Problem with IF function


You need to use the LEFT function. See my post above


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=502920