When you want to apply a small tweak to the document, it should not take long to Affix spreadsheet record. This sort of basic action does not have to require extra education or running through handbooks to learn it. Using the appropriate document modifying instrument, you will not spend more time than is needed 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 using a web-based editor service. This instrument will take minutes or so to figure out how to Affix spreadsheet record. 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 devote to document modifying no matter your previous experience with this kind of instruments. Make an account now and boost your efficiency instantly with DocHub!
Hello Everyone. Welcome to Excel 10 Tutorial. In this quick tutorial I will show you how to add suffix and prefix at a time in Microsoft excel. Im going to show you two ways to do so. OK? You can see the prefix is Food and the word Im going to add it with these vegetables names and the suffix is vegetables. OK? So I want the output here in D2 cell. The first procedure includes To write the formula Im going to write the prefix inside the formula and then select the word and then suffix. OK? So, Ive already written Im going to paste it in the function bar You can see that the function is =CONCATENATE() Then I have written the word food which is in cell A2 and then I select the cell no B2 Different vegetables names will be in this column so I just select the first one Cell B2. And after that Ive written the word vegetables. Ok? So, If I press Enter you can see Ive successfully added Suffix and Prefix. Here is the Prefix Food then the word which is in cell B2 and then the suffi