Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Problem with search
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
Baffling formula problem | Excel Discussion (Misc queries) | |||
Search for a Sheet | Excel Discussion (Misc queries) | |||
Paper Tray selection Problem, | Excel Discussion (Misc queries) | |||
Problem with search | Excel Worksheet Functions |