Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel MID(RtGet())

Status
Not open for further replies.

Funkymatt

Programmer
Aug 27, 2002
101
US
=MID(RtGet("Telerate","19901","IRGROW 18"),21,7)

Trying to determine what this guy pulls. Telerate is the service the data is being pulled from and 19901 I'm guessing is the specific view/screen....do you think the IRGROW 18 is the 18th row? the 21,7?

Thanks,
Matt
 


Hi,

What RtGet does need to be verified by looking at that function.

21, 7 means -- with the return string fto RtGet, return the 21st character for the next 7 characters.

Skip,

[glasses] [red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top