| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
inserting value if another cell contains a specific word
Use this instead.........
=IF(ISERR(MID(B2,FIND(" ",B2,1)+1,99)),"",MID(B2,FIND(" ",B2,1)+1,99)) Vaya con Dios, Chuck, CABGx3 "exceluser2" wrote: great! For the cell "NoMadic" which has no value after it I get the #VALUE! error. How can I change this to just a blank cell? -- exceluser2 ------------------------------------------------------------------------ exceluser2's Profile: http://www.excelforum.com/member.php...o&userid=31338 View this thread: http://www.excelforum.com/showthread...hreadid=517917 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| delete a cell if it contains specific word | Excel Discussion (Misc queries) | |||
| Excel 2003 Word Wrap Problem within cell | Excel Discussion (Misc queries) | |||
| Inserting extra info into a cell | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Hybrid Mode
