Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi! I have a matrix that contains names of companies and some info about
these compaines. For every company there is an array that contains rating info. These ratings are written with a special syntax. What I want to do is to find which rating agency is used. The ratings are written with a special syntax. First comes three letters and an underscore and then comes (an abbrevation of) the name of the ratingagency. Eg a raing looks like: RTG_SP*. Here I want to single out the SP. The start indicates that there might be additional info that I am not intreseted in. There are only three rating agencies that I want to single out; SP, MDY and FITCH. But how do you check an array and look for the names? Please any help appreciated! Thanks alot! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
checking for a particular string in a cell | Excel Worksheet Functions | |||
checking for a string & No. | Excel Worksheet Functions | |||
Spell Checking a String | Excel Programming | |||
Checking to see whether a string contains a certain character | Excel Programming | |||
Checking the value of the end of a string | Excel Programming |