Hi
then try
=IF(ISNUMBER(FIND(" ",A1)),MID(A1,FIND(" ",A1)+1,1024),A1)

P.S.: best to post your tried formula
--
Regards
Frank Kabel
Frankfurt, Germany

"Manu Palao" schrieb im
Newsbeitrag ...

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