Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Problem with search
I am not sure whether I understood your question. If you saying that you are getting error when length of contents in the cell is <1., you can use if criteria to see whether the length of the cell content 1 and process your macro according to that. =IF(LEN(D5)1,SEARCH("",D5,1),"") 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!! -- anilsolipuram ------------------------------------------------------------------------ anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271 View this thread: http://www.excelforum.com/showthread...hreadid=277029 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Windows search in Excel with autofilter | Excel Discussion (Misc queries) | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
Q: search in string | Excel Discussion (Misc queries) | |||
Paper Tray selection Problem, | Excel Discussion (Misc queries) | |||
search & replace | Excel Worksheet Functions |