| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
cusip (number and text) in same cell- How do use in excel?
I need to define cusips in excel in an if/nested if statement
Example Cell A1=005482J86 Cell A2=0162483G9 How do i use and if/or logic statement to make a true statement equal "Muni bond" (cell b1) or "Corp Bond"(cell b2) I cannot get excel to recognize any logic statement since a cusip has numbers and text!! Please help! Thanks in advance !! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 16 digit number wont keep alteration unless format cell to text | Excel Discussion (Misc queries) | |||
| Defining a number in a cell by text then subtracting it by the tex | Excel Worksheet Functions | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
| returning a text cell based on a number cell | Excel Worksheet Functions | |||
Threaded Mode
