That's true. Most popular sans families have highly condensed versions. Akzidenz Grotesk has one that is often used. If you are trying to match a specific typeface, look at the G, M and R as quick keys. If there is a lower case, the a, e, g and y are keys I use.
There are also fonts like Huxley, Compacta, Malstock, Roswell, Iris and Empire that were designed as ultra compressed fonts. There are even some serif fonts, like Bordeaux, Heliotype, Modula Serif and Robotik. I think I have seen most of these used for movie credits over the years.
Fredrich, I don't think there's a standard, probably more just a style that's used more often than others over different periods of time. Some of the ones Bowfinpw mentioned would also work well. The key is the compressed look, not so much the particular font.
"Lucy, you got some 'splainin' to do!" - Ricky Ricardo
Univers 39 Thin Ultra Condensed is a common choice, but as urstwile says, it's not cast in concrete. In case you weren't aware of it, the reason for these outrageously tall skinny fonts in this context is that when you look at them from below at a sharp angle, the foreshortening makes them more readable. That's also why so many poster fonts have those immensely thick slab serifs: viewed from street level and close up, they foreshorten into something that looks quite normal.
I am trying to find a software that will do the following things, I don't need an expensive program, I don't want to buy an expensive program. I am a newb but I'm not an idiot but man, some of the programs...