string

Excel VBA – What is SPLIT Function?

Splitting people OR friends may not be a good idea :) but Splitting data or string becomes necessary to organize it and to put it in more readable format. Here in this article, you will learn about splitting the data/string which is joined with a specific delimiter. Delimiter could be any character or special character. This VBA function basically finds [...]

Custom Formula to Reverse a String in Excel

Dear Friends,   This is a very small but useful Custom Function which can be used to reverse a string in excel. In VBA (Excel Macro) there is an Inbuilt function to reverse a string but in Excel Formula there is no formula as such to reverse a string. Using that built-in function you can create your own custom formula [...]

VBA Programming : String Manipulation

Many a times, we come across to deal with Strings. Like Length of the String, Concatenating two or more Strings etc. This article teaches you how to deal with strings with the following different operations: 1. Concatenating Strings (Joining Strings) 2. Finding Length of a String (Len Function) 3. Remove Spaces from a String (Trim Function) 4. Left Function 5. [...]

VBA: Reverse a string

It is very easy to get the Reverse of a string entered by user in Excel VBA by using VBA inbuilt functionality. strReverse() is the inbuilt function which returns reverse of the String given as input to this function. Syntax: strReverse("Your Input String") Returned Value: It returns a reversed string of your given input String. Example:Below code will return the [...]