Excel splicing function realizes template generation: in short, it is splicing fields. For example, in our life, there are two lines of fields in Excel, the name and phone fields. For example, we can add a column to splice out the format of 'name: phone'. When we modify the name and phone, we do not need to modify the newly added splicing fields, which will come into use at this time~.
What I want to do now is to compile a string of messages into a SMS template, with customized content and fixed beginning and end. We can adopt this method.
At present, the contents in Excel are as follows:
What I want to achieve is that when modifying any prefix, suffix and self-evaluation content, the generated SMS sending template can remain unchanged.
Implementation steps:
1) First set the format in the table to normal (important!)
2) Use string splicing syntax to splice =G2&D2&F2&H2
&
Is a concatenated character; Others are the contents of cells
3) If you want to splice punctuation, remember to use &" "&
that will do
4) Of course, it can also be applied to splicing SQL, such as the following: