Click Ok or Apply. Click Evaluate multiple times. How to Create a Formula in Excel.
Select a blank cell enter formula CharacterSUBSTITUTE Cell Reference Character into the Formula Bar and then press the Enter key.
Click Evaluate multiple times. Add Subtract Multiply and Divide more Written by co-founder Kasper Langmann Microsoft Office Specialist. Easily add words from different cells together with Kutools for Excel. Select the cells you need to combine together and expand the selection to a blank column to place the added words.