Help explain, EXCEL function of usage, there are accessories.
[Users questions | Browse:222 | Favorites]
Users questions: The function of the conditions of the formula: = B3 =** MID ($ H $ 1, COLUMN () -1,1) MID front of the two "**" is used for? Back, COLUMN () -1, is What does it mean?
Experts answer: explained: 1, B3, the formula "=** M ID ($ H $ 1, COLUMN () -1,1) "means: Take H1 string, the first one started a total of a specified character. 2, MID ago "**", is to get the character change to digital format. 3, COLUMN (), is listed in their cell number, in B3, The column number is 2, then the COLUMN () -1 = 1. 4, at C3, the formula "=** MID ($ H $ 1, COLUMN () -1,1)" means is: Take H1 string , No. 2 started a total of a specified character in the other and so on.
Experts answer: explained: 1, B3, the formula "=** M ID ($ H $ 1, COLUMN () -1,1) "means: Take H1 string, the first one started a total of a specified character. 2, MID ago "**", is to get the character change to digital format. 3, COLUMN (), is listed in their cell number, in B3, The column number is 2, then the COLUMN () -1 = 1. 4, at C3, the formula "=** MID ($ H $ 1, COLUMN () -1,1)" means is: Take H1 string , No. 2 started a total of a specified character in the other and so on.
- 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?
- Why not let me see My Network Places?
- EXCEL delivery table and more, how do
- How does the situation need to find the product selection?
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.