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

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

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