VBA is a very good tool to manage data. I always write some mini VBA programs to manipulate database data and create SQLs. Apart from programming, it also gives me some valuable memories with Tinyan
Let’s back to the topic. In VBA, we use Mid() to substring.
'Mid(String, Start As Long, [Length]) aString = "ykyuen.wordpress.com" myLastName = Mid(aString, 3, 4) 'Return "yuen" to myLastName
Done =)
Reference: Tech on the Net – Excel: Mid Function
Thank you so much!
Had trouble finding this in the docs.
Good to know that i could help. =D
Such a simple blog. And its the first return on Google search. God bless
You are welcome. =)
Yeah, very helpful. Thanks for keeping it simple and straightforward.
Thanks for your comment and i am glad to know that it is helpful for you. =)