[Excel] Split and join the string in an instant!How to use a flash fill that increases work efficiency with Excel
- 697
- 98
[Excel] Split and join the string in an instant!How to use a flash fill that increases work efficiency with Excel
- By huaweicomputers
- 11/06/2022
"Flash fill" that can be divided and bonded without using a function!
You often use Excel to create employees and customer list.Have you ever wanted to input "name" and "name" from "name" entered in one cell?Also, have you ever wanted to combine the "surname" and "name" entered in different cells and enter them into one cell?
Do you know that Excel has a function called "flash fill" and that such a character string and bond can be completed in an instant?This "flash fill" function automatically performs the same processing to subsequent cells based on the input rules of the first cell.
This time, I will explain how to divide and bond the string entered in the roster using the Excel flash fill in instantaneous.
Divide the "name" entered in the roster into "surname" and "name"
Let's use the example of the next "△ Shokai customer list".Divide the "name" entered in column B (①) in this list into "surname" and "name", and enter in column C (②) and column D (③), respectively.
この名簿のB列（①）に入力されている「氏名」を「姓」と「名」に分割して、それぞれC列（②）とD列（③）に入力As mentioned earlier, the flash fill is a function that automatically performs the same processing on the cells based on the input rules of the input when entering data in the first cell, so first of all, column C in the list.Enter "surname" in the lead cell.Enter "Kimura" (④) in the cell C4 and press the [Enter] key.
セルC4に「木村」（④）と入力して［Enter］キーを押すCheck that the active cell is in any cell in column C (⑤), and click the Data tab (⑥) → [Flash Philharmonic] (⑦).
アクティブセルがC列のいずれかのセルにあること（⑤）を確認して、［データ］タブ（⑥）→［フラッシュフィル］（⑦）をクリック
Then, "Surname" was instantly entered in all cells after C5 C5 (⑧)!Not all data is displayed due to the screen for the screen, but the surname is entered in all cells in column C.
C列のセルC5以降のすべてのセルに、一瞬で「姓」が入力されました（⑧）Similarly, let's enter "name" in column D.First, enter "Yuri" (⑨) in the cell D4 and press the [Enter] key.
セルD4に「由利子」（⑨）と入力して［Enter］キーを押すCheck that the active cell is in any cell in column D (⑩) and click [Data] tab (⑪) → [Flash Philharmonic] (⑫).
アクティブセルがD列のいずれかのセルにあること（⑩）を確認して、［データ］タブ（⑪）→［フラッシュフィル］（⑫）をクリックAs mentioned earlier, "name" was entered in all cells after the Color D5 in column D (⑬).
D列のセルD5以降のすべてのセルに「名」が入力されました（⑬）Let's combine and display the "surname" and "name" entered in the roster
This time, let's consider the opposite pattern from the previous one.Combine the "surname" entered in column B (①) in the next list and the "name" entered in column C (②), and display it as "name" in column D (③).increase.
B列（①）の「姓」とC列（②）の「名」を結合して、D列（③）に「氏名」として表示してみますThe idea is the same as when the name is divided into "surname" and "name" earlier.First, enter "Yuri Kimura" (④) in the cell D4 at the top of column D and press the [Enter] key.
D列の先頭のセルD4に「木村 由利子」（④）と入力して、［Enter］キーを押すCheck that the active cell is in any cell in column D (⑤) and click the [Data] tab (⑥) → [Flash fill] (⑦).
アクティブセルがD列のいずれかのセルにあること（⑤）を確認して、［データ］タブ（⑥）→［フラッシュフィル］（⑦）をクリックThen, all cells after the cell D5 in column D were entered with "name" that combined "surname" and "name" (⑧).
D列のセルD5以降のすべてのセルに、「姓」と「名」を結合した「氏名」が入力されましたUse a flash fill to improve your work efficiency
This time, we explained how to divide and bond the string entered in the roster using the Excel flash fill in an instant.
Literally, many people may be surprised that the strings were split and bonded in an instant.
However, the flash fill may not work.In this example, if there is no separated character such as blank between "surname" and "name", it will not work.Without a separated character, it is difficult for Excel to judge the "surname" and "name".
In any case, there are many situations where you can use this function to improve work efficiency.Please use it by all means.
