Archive List for October 2017

Line feed code/CHAR(10), replace・delete, CHAR function

Basic Course

Insert a new line in cells (Using a code) To insert a new line in Excel, we can add a text called ‘line feed code = CHAR (10)’. Let us review this line feed code first. → For more information on the CHAR function, click here   Example of use) Insert a new line using・・・

【Practice question】Sum up values that meet a condition_

Practice Course

Practice question 1/Sum up cells that includes a specific text 【Practice question 1 : Question】 The table below shows the number of employees in each office. In each region, there is a department that supervises the offices (branches) named the ‘supervisory’ department. Calculate the number of employees in the ‘supervisory’ department. The total number of・・・

To the top