HomeApplicationOffice informationHow to insert characters at the beginning or end of a string

How to insert characters at the beginning or end of a string in Excel

Recently Software Tips received many questions asking how to insert characters at the beginning or end of a string in Excel. So today, Dexterity Software introduces readers how to insert more characters into the string in this article, invite you to track.

How to insert characters at the beginning or end of a string in Excel Picture 1

Use the CONCATENATE function

The CONCATENATE function is a function that helps concatenate characters in Excel. Put the keywords that need to be concatenated in sequence in the function: = CONCATENATE (text1, [text2], .)

For example, if you have the following data table, you need to insert character A at the beginning of character Z at the end of the string. The formula will be as follows:

How to insert characters at the beginning or end of a string in Excel Picture 2

Notice the results on the words "Jutsu" and "Part" are stuck together due to the lack of spaces. So you should add spaces to the formula as follows:

How to insert characters at the beginning or end of a string in Excel Picture 3

Alternatively, you can use the following CONCATENATE function argument as follows:

How to insert characters at the beginning or end of a string in Excel Picture 4

Use the & character

Similar to the CONCATENATE function, you can use the & character following the following example:

How to insert characters at the beginning or end of a string in Excel Picture 5

Or the argument is a text character:

How to insert characters at the beginning or end of a string in Excel Picture 6

Above Software Tips guide you to read how to insert characters at the beginning or end of a string in Excel. Good luck!

5 ★ | 1 Vote

You should read it

May be interested

  • Wrap text in WordPhoto of Wrap text in Word
    quite a few users know about the wrap text tool in word that is used to adjust the appearance of images compared to text beautifully. so today, dexterity software will introduce to readers how to insert images and adjust the position of images and text content accordingly!
  • How to copy from Excel to Word without framesPhoto of How to copy from Excel to Word without frames
    when copying data from excel to word, the software will default to the data accompanying the frame. so in case you just want to copy the data without the accompanying frame?
  • How to remove periods in numbers in ExcelPhoto of How to remove periods in numbers in Excel
    how to remove periods in numbers in excel when typing a string of numbers, data entry people have a habit of inserting dots in the middle to easily observe the data and reduce errors when entering data. however, in some cases, the dot will make the calculation impossible.
  • How to paste data into non-hidden cells, ignoring hidden cellsPhoto of How to paste data into non-hidden cells, ignoring hidden cells
    the copy tool - paste is a useful tool in excel. however, to best use this tool, not all users know it. in this article, dexterity software teaches you how to paste data that ignores hidden cells.
  • 3 How to rotate a PDF file and save it as the simplest new filePhoto of 3 How to rotate a PDF file and save it as the simplest new file
    you have a pdf document and you need to read it, but when you open it, all the words are rotated horizontally or reversed? use one of the three ways to rotate a pdf file and save it as the simplest new file that tipsmake.com introduces below.
  • How to use Vlookup function between 2 sheets, 2 different Excel filesPhoto of How to use Vlookup function between 2 sheets, 2 different Excel files
    how to use vlookup function between 2 sheets, 2 different excel files. normally the vlookup function applies on the same file in a certain workbook, but in some cases where the work is not so simple, the condition area and the area you need to access the data belong to belongs to two other sheets. together

Office information