How to delete the spaces at the beginning and end of a string in excel?

To delete the spaces at the beginning and end of a string in excel, you can directly use the find and replace function, or you can use the following formula: Select an applicable text without spaces = substitute (A 1, "","") = trim (A 1).

1. Take the following example to illustrate that connecting "school code" with "college code" and "college number" becomes "student number"

First, connect the following strings; The second type: use "-"to connect below.

2. Let's talk about the first method first, and use the connecting symbol: "&".

This method is the simplest, just use "&"in each cell. Just connect it. If other characters (such as "-") are added between strings, just connect the symbol "-"between strings.

3. The second method is to use string concatenation function: CONCATENATE () function.

Its usage is simple: CONCATENATE (cell to be connected, cell to be connected, cell to be connected ...)