Problem with search

M

Manu Palao

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

Frank Kabel

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

P.S.: best to post your tried formula
 
Top