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.
LikeLike
Good to know that i could help. =D
LikeLike
Such a simple blog. And its the first return on Google search. God bless
LikeLike
You are welcome. =)
LikeLike
Yeah, very helpful. Thanks for keeping it simple and straightforward.
LikeLike
Thanks for your comment and i am glad to know that it is helpful for you. =)
LikeLike
Use
Replace(expression, find, replace[, start[, count[, compare]]])
LikeLike
Thx for your comment~ =)
LikeLike