In my many years of rummaging through the internet for help, I have seen countless posts where troubled help seekers are told that VBA does not have a built in function to reverse a string. Amature know-alls suggest a makeshift solution using a for-loop; and everyone is happy. Contrary to popular belief, Visual Basics does have a built in function to reverse a string: StrReverse()
For the benefit of Excel-VBA beginners, I thought I would post a Wrapper function that would make this functionality available in the Excel Interface.
Function StringReverse(ByVal WhichString As String) As Variant
StringReverse = StrReverse(WhichString)
End Function
I specialized in actuarial science in my masters’ program and I am determined to become a qualified actuary. I invest extra time and effort into creating intuitive spreadsheet applications that improve productivity at the workplace.
I also enjoy spending my leisure time creating digital art; I publish my designs on my art in this blog named Designecdotes.
Most of the people who have dramatically influenced my life were enthusiastic academicians. I believe that the greatest gift in life is having a nurturing mentor, and I would like to be that for someone. I owe it to my future mentees to be the best at what I do, and I consciously direct my endeavors at gathering what I consider essential traits of a seasoned mentor.
View more posts
3 thoughts on “Reversing a string in Excel”
This is quite amazing! I never knew hat they had such function in Excel 🙂 Thanks for this awesome posting.
This is quite amazing! I never knew hat they had such function in Excel 🙂 Thanks for this awesome posting.
LikeLike
Hi Erica, One thing a Day – Accomplished!
Even I came to know about this only recently.
LikeLike
Reblogged this on Sutoprise Avenue, A SutoCom Source.
LikeLike