ExcelExcelで改行を基準にセルの内容を分割！TEXTSPLIT関数で簡単操作
Excelで改行を基準にセルの内容を分割！TEXTSPLIT関数で簡単操作Excelで複数行に渡るデータを扱う際に、セル内の改行を基準にしてデータを分割したい場合があります。たとえば、住所情報やリスト形式のデータを個別のセルに分けたいケース...
Excel
Excel
ExcelExcelで日時から時刻部分のみを取り出す方法と計算式：関数を使った簡単な手順
Excelで日時から時刻部分のみを取り出す方法：MOD関数を使った簡単な手順Excelで日時データを扱っていると、日付部分を除いて時刻部分だけを抽出したい場合があります。例えば、特定の時間帯のデータを分析したいときなどに便利です。本記事では...
ExcelExcel macro that automatically generates a pattern list of combinations
How to Auto Generate Combinations in Excel VBA MacroThis article will show you how to auto generate a combination of dif...
ExcelWhat is “exponential” in Excel’s display format?
When you select "Exponential" as the Excel display format, the numbers in that cell are displayed in scientific notation...
ExcelWhen I enter a number with brackets in Excel, it is converted to a minus sign.
In accordance with common accounting practice, Excel displays negative numbers in parentheses. Thus, if you enter a numb...
Excel VBA MacroIt only takes one shot! How to bulk replace destination addresses of hyperlinks in Excel workbook
It only takes one shot! How to bulk replace destination addresses of hyperlinks in Excel workbookIf you want to replace ...
ExcelTo print at the maximum size that fits on one page
In Excel, I will introduce how to print a worksheet as enlarged as possible.It is a procedure to expand as long as it do...
ExcelCount specific characters “other than” with COUNTIF function
COUNTIF functionLearn how to count non-specific characters with the COUNTIF function.The format of the COUNTIF function ...
ExcelCount specific characters “other than” with COUNTIF function
COUNTIF functionLearn how to count non-specific characters with the COUNTIF function.The format of the COUNTIF function ...
ExcelUse “none” inside an IF function
Basic form of the IF functionIf the in column A is "○" when it is "star", and if it is "×" otherwise, use the IF functio...