In the previous post, we talked that how to add the same text into the beginning of the text in one cell or all selected cells. And this post will guide you that how to add the specified text or characters to the end of all cells in excel. How to create an excel formula to add same text string or characters to the end of text string in one Cell. How to create an excel macro to add specific text to the end of the text in all of cells.
Add text to the end of all cells with Formula
For example, if you want to add text “excel” into the end of the text in Cell B1, you can use the following excel formula:
= B1&" "& "excel"
You can enter the above formulas in Cell C1, and then drag the fill handle down to other cells in column C and you will see that the specified text “excel” has been added into the end of the text string in B1.
Add text to the beginning of all cells with Excel VBA
You can create a new excel macro to add text string “excel” to the end of text in Cell B1 in Excel VBA, just refer to the below steps:
1# click on “Visual Basic” command under DEVELOPER Tab.
2# then the “Visual Basic Editor” window will appear.
3# click “Insert” ->”Module” to create a new module
4# paste the below VBA code into the code window. Then clicking “Save” button.
Sub addTextAtEndCell() Dim e as range For each e in Selection If e.value <> "" Then e.value = e.value & "excel" Next End Sub
5# back to the current worksheet, then run the above excel macro, you will see that the specific text “excel” has been added into the end of the text in all selected Cells.
Add text to the beginning of all cells
If you want to add the specific text or characters into the beginning of the text in one cell or all cells, you can create an excel formula based on the concatenate operator or CONCATENATE function.…
How to join text from two or more cells into one cell separated by commas, space
You can merge text from two or more cells into one cell using a combination of the SUBSTITUTE function, the TRIM function and concatenation operator to create an excel formula..…
Combine columns without losing data
How to keep all data after merging columns. You can use the concatenate operator or CONCATENATE function to create an excel formula. Assuming that you want to merge column B and C into column D, you can use the following formulas:=B2&C2 OR =CONCATENATE(B2, “ “ ,C2).…
How to Extract Text between Commas
To extract text between commas in Cell B1, you can use the following formula based on the SUBSTITUTE function, the MID function and the REPT function.…
How to Combine Text from Two or More Cells into One Cell
If you want to join the text from multiple cells into one cell, you also can use the CONCATENATE function instead of Ampersand operator..…
Excel Concat function
The excel CONCAT function combines 2 or more strings or ranges together.This is a new function in Excel 2016 and it replaces the CONCATENATE function.The syntax of the CONCAT function is as below:=CONCAT (text1,[text2],…)…