HomeApplicationOffice information

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

  • Instructions on how to count words in cells in ExcelInstructions on how to count words in cells in Excel
    in many cases you want to count the number of characters in a text string (text string) to calculate or combine with other functions, or to do something. you can then use the trim function, combining the len function, the substitute function. using the trim function to remove spaces, use the substitute function to replace the current text with new text in a text string, ...
  • MID and MIDB functions to cut strings in ExcelMID and MIDB functions to cut strings in Excel
    the mid () function returns a string from a text string, with the position to start extracting from the text string and the number of characters returned by the string that is specified. functions used in languages ​​use a single-byte character set (sbcs) and always count each character as 1.
  • How to use Excel's VALUE functionHow to use Excel's VALUE function
    excel's value function will convert a string to a digital form, which can be combined with other functions such as left function, right function, mid function.
  • Insert special characters in Word documentsInsert special characters in Word documents
    introduce how to insert special characters for a text page in word. step 1: place the cursor at the position where you want to insert special characters - on the insert tab - symbols - symbol - select the characters to insert.
  • How to Manipulate Strings in JavaHow to Manipulate Strings in Java
    strings are sequences of characters. for example, 'hello!' is a string because it is made up of the characters 'h', 'e', 'l', 'l', 'o', and '!'. in java, strings are objects, which means that there is a string class that has fields and...
  • How to insert a Word document into an Excel fileHow to insert a Word document into an Excel file
    to be able to open word text files right in excel file, we can use the built-in feature to allow inserting data right on excel.
  • How to split strings in ExcelHow to split strings in Excel
    in excel when working with character strings, there are many cases where it is necessary to split a string to use the data, but the amount of data needs to be separated quite large, if merely manually doing it takes a lot of time and effort. strength. the following article guides to
  • How to insert watermark, logo sink into ExcelHow to insert watermark, logo sink into Excel
    inserting a logo into an excel file will help stamp documents, avoid copying content.
  • How to use MID functions to get strings in ExcelHow to use MID functions to get strings in Excel
    mid function in excel is a function that takes the middle character string corresponding to the value that the user requires to perform.
  • RIGHT () and RIGHTB () functions in ExcelRIGHT () and RIGHTB () functions in Excel
    the right () function returns the result as one or more final characters in a text string based on the number of characters you give. the right () function always comes with every 1 character whether it is single byte or double byte or whatever the default language is.

Office information