Category Archives: Adding/Concatenating Strings

tony stark is iron man

All About Concatenate in Excel and VBA

In Excel, text concatenation is a common task which can be accomplished easily with the CONCATENATE function or with the “&” operator. For example, to concatenate “AB”, “CD”, “EF”, we can use Excel formula: =CONCATENATE(“AB”,”CD”,”EF”) or =”AB” & “CD” & “EF” In this tutorial, we

No Thumbnail

Excel VBA Strings: Common Errors When Using Strings

In this article I will explain some of the most common errors people encounter while working with strings. For more information regarding string commands please visit VBA Excel String Processing and Manipulation. You can download the codes and files related to this article here. Jump To:

No Thumbnail

VBA Excel String Processing and Manipulation

When you are working with strings, string processing and manipulation is an important tool. Whether you want to search for a certain expression in a string, split a string, add multiple strings … you will have to be familiar with the concepts of string processing.

No Thumbnail

Excel VBA, Currency Exchange (Forex) Sheet, (Sample Code and Download)

In this article explain how you can write an excel application to retrieve currency exchange (forex) rates from the website This application also allows users to select only the currency exchange (forex) rates he/she needs. You can download the codes and files related to this article