Hi
the problem arises when the cell only has a word. When I try to get the
position of the blank character (to be able to separate the first word
by means of MID function), there is an error, because there is no blank
in the cell.Thanks!


--
Manu Palao
------------------------------------------------------------------------
Manu Palao's Profile: http://www.excelforum.com/member.php...o&userid=16205
View this thread: http://www.excelforum.com/showthread...hreadid=277029