Manu Palao Wrote:
Hi
In a macro, I´m trying to get the first word of every cell. I use the
function Search("",1). This works when there are several words in a
cell, but there is a runtime error when there is only one, since there
are no blanks in the cell. What could I do? Thanks!!

=LEFT(A1,SEARCH(" ",A1&" ")-1)


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=277029