Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Substring
#3
Not Solved
Hi,

I suggest the below script, try it once:

Code:
strMonthlyPremium = "$87.67"
strAnnualPremium = "$1,052.00"

MonthlyPremium=right(strMonthlyPremium,len(strMonthlyPremium)-1)
AnnualPremium=right(strAnnualPremium,len(strAnnualPremium)-1)

msgbox MonthlyPremium
msgbox AnnualPremium

Thanks & Regards,
Uday.
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,939 10-04-2016, 09:15 PM
Last Post: venkatesh9032

Forum Jump:


Users browsing this thread: 2 Guest(s)