Learn Microsoft Excel Training from the Best Tutors
Affordable fees 1-1 or Group class Flexible Timings Verified Tutors RIGHT function in VBA returns the Specified number of characters from the end of a text string
Syntax: Right(String,Length)
Sub RIGHT_1()
Dim mystring As String
mystring = "Narendra Modi"
MsgBox Right(mystring, 4)
'Output: "Modi"
'To get first name dynamically use RIGHT & InStr functions
MsgBox Right(mystring, Len(mystring) - InStr(1, mystring, " "))
'Output: "Modi"
End Sub
Find Microsoft Excel Training classes near you
Learn from Best Tutors on UrbanPro.
Are you a Tutor or Training Institute?
Join UrbanPro Today to find students near youThe best tutors for Microsoft Excel Training Classes are on UrbanPro
The best Tutors for Microsoft Excel Training Classes are on UrbanPro
0
