If you want to apply a minor tweak to the document, it must not take long to Concatenate initials certificate. This type of simple activity does not have to demand additional education or running through guides to understand it. Using the right document modifying tool, you will not take more time than is necessary for such a quick change. Use DocHub to simplify your modifying process whether you are a skilled user or if it is your first time making use of a web-based editor service. This instrument will require minutes or so to learn to Concatenate initials certificate. The sole thing needed to get more effective with editing is actually a DocHub account.
A simple document editor like DocHub will help you optimize the time you need to spend on document modifying irrespective of your prior knowledge of this kind of resources. Create an account now and improve your efficiency instantly with DocHub!
if you have a data set that has a column for folks first name and a column for their last name and you want to put it together in the same cell with just their first name initial a dot a space and then their last name you can do that using the concatenate and the left function im going to show you how to do that right now so the first thing we do is write equals concatenate because were going to bring in the contents from two separate cells and bring it into one and thats what concatenate means in excel language and then this first bit of text that we want to bring in is just the first initial the first name so we do that by using left and were looking the text that were using is the first name text and we only want the first letter so we put 1 in there meanwhile if we were to put 2 it would return j i it would produce the first two letters starting from the left but we only want the first one so we put one now to put the dot in the space we put a comma after the first part of th
