| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
inserting value if another cell contains a specific word
Row | Collumn1 | newcollumn | 1 | Thoughts MN | MN | 2 | 120Agents target | target| 3 | Eldoradonet target | target | 4 | eBorkin target | target | 5 | Flightair NP | NP | 6 | Getcardshere target | target | 7 | NoMadic | | 8 | timetoeat target CONVER | target CONVER | 9 | 4usa default time | default time | Using the text in collumn1 i.e. "Thoughts MN" I need to create a new collumn that would insert values based upon specific words in collumn1. The above tries to show what I need. The function would need to insert the values into newcollumn if it matches a word in collumn1. the words are MN , target, NP, target CONVER, default time and a blank space Thanks for the help -- exceluser2 ------------------------------------------------------------------------ exceluser2's Profile: http://www.excelforum.com/member.php...o&userid=31338 View this thread: http://www.excelforum.com/showthread...hreadid=517917 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
inserting value if another cell contains a specific word
Assuming your data is in column A and there are no leading spaces in the
cells, and there is a trailing space on cells that do not have at least two spaced words...put this in B1 and copy down.......... =MID(A1,FIND(" ",A1,1)+1,99) Vaya con Dios, Chuck, CABGx3 "exceluser2" wrote: Row | Collumn1 | newcollumn | 1 | Thoughts MN | MN | 2 | 120Agents target | target| 3 | Eldoradonet target | target | 4 | eBorkin target | target | 5 | Flightair NP | NP | 6 | Getcardshere target | target | 7 | NoMadic | | 8 | timetoeat target CONVER | target CONVER | 9 | 4usa default time | default time | Using the text in collumn1 i.e. "Thoughts MN" I need to create a new collumn that would insert values based upon specific words in collumn1. The above tries to show what I need. The function would need to insert the values into newcollumn if it matches a word in collumn1. the words are MN , target, NP, target CONVER, default time and a blank space Thanks for the help -- exceluser2 ------------------------------------------------------------------------ exceluser2's Profile: http://www.excelforum.com/member.php...o&userid=31338 View this thread: http://www.excelforum.com/showthread...hreadid=517917 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
inserting value if another cell contains a specific word
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 |
|
#4
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
