Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Substring
#1
Not Solved
I would like to take out the yearly premium from this string:
The estimated monthly premium* is $87.67
The annual Premium for this coverage is $1,052.00

Which function should I use? I am looking at split but I do not see an example on how to use it. Let me rephrase that .. I do not understand the example. Not sure what this is MyArray = Split(MyString, "x", -1, 1) .. -1? In any case if this is the appropriate function how do you use this and if there is a better one, what is it and how do you use that one?
Reply


Messages In This Thread
Substring - by Anna - 07-16-2008, 07:11 PM
RE: Substring - by anemuday - 07-20-2008, 10:36 PM
RE: Substring - by bhanu_bp7 - 07-21-2008, 03:16 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  VBA Code to read a substring Dwarak Calayampundi 2 2,557 10-04-2016, 09:15 PM
Last Post: venkatesh9032

Forum Jump:


Users browsing this thread: 1 Guest(s)