开发者

Concatenation function: splitting and merging cells

Assuming column A23 (#) is 22, B23 (Last name) is Daniell开发者_StackOverflow社区e, C22(middle name), D22 (last name) is Anderson.

This example has no middle name.

By using the =CON I want a combination of the first letter in the student’s first name, the first letter in their middle name and the first 6 letters of their last name. If the student does not have a middle name, the number in the A column and corresponding row should be used. If the student’s last name is shorter than 6 letters, their full last name should be used.


=left(B23,1) & if(C22<>"",left(C22,1),A23) & left(D22,6)
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜