VBA (Visual Basic for Applications) is the programming language used to create macros. A good knowledge of VBA can save time and make you a much more productive Excel user. VBA is a common programming language found in virtually all Microsoft Office applications. People will often learn VBA before progressing to other languages in due course.
This VBA Quick Tip will show you how to change some of the characters in a cell. This could be useful if you had names in a list and you wanted the first name bold but not the rest you could modify this code and use it. In the first line you will see that you need to choose what the range of rows you are going to use. The code below will actually turn the first 3 characters italic then it will change the name after it to bold. To modify the formatting of specified characters, use the Characters object.
This is the result you will get and as you can see the first two characters are in italic and the names are in bold. Feel free to tweak the code and make it useful for yourself to use in your workplace or at home.