How to automatically generate EXCEL in the first letter of the name
[Users questions | Browse:41 | Favorites]
Users questions: How to automatically generate in EXCEL in the first letter of the name that I enter one in the first column name, like automatically generated in the second column in their first letters, thank you
Experts answer: = LOOKUP (CODE (A1), 45217 + (0,36,544, 1101,160 9,1793,2080,2560,2902,3845,4107,4679,5154,5397,5405,5689,6170,6229,7001,7481,7763,8472,9264},{ A , B "," C "," D "," E "," F "," G "," H "," J "," K "," L "," M "," N "," O ", "P", "Q", "R", "S", "T", "W", "X", "Y", "Z")) Reference: http: ** p ost.baidu.com*f?ct=335675392&tn=baiduPostBrowser&sc=2505763346&z=255658576&pn=0&rn=50&lm=0&word=exce l # 2505763346
Experts answer: = LOOKUP (CODE (A1), 45217 + (0,36,544, 1101,160 9,1793,2080,2560,2902,3845,4107,4679,5154,5397,5405,5689,6170,6229,7001,7481,7763,8472,9264},{ A , B "," C "," D "," E "," F "," G "," H "," J "," K "," L "," M "," N "," O ", "P", "Q", "R", "S", "T", "W", "X", "Y", "Z")) Reference: http: ** p ost.baidu.com*f?ct=335675392&tn=baiduPostBrowser&sc=2505763346&z=255658576&pn=0&rn=50&lm=0&word=exce l # 2505763346
- There are several new methods of presentation, simply out of.
- What word in how to increase the special symbols
- excel how to filter and distinguish between the number of consecutive
- How will the characters in the cell and breakdown of figures show?
- How to set excel in the integer "0" format
- How to convert PDF text editable word or TXT
- How could such a problem?
- Help explain, EXCEL function of usage, there are accessories.
- Why not let me see My Network Places?
- EXCEL delivery table and more, how do
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.