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 |
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 |
All times are GMT +1. The time now is 12:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com