# Tag Archives: IF

## Excel, Functions and Formulas, Tutorial / Sample, Text and Strings #2 (Advanced)

Today when I was looking through the stackoverflow forum, I came up to this question: vba-clean-up-conditional-duplication-of-rows Though the question was actually VBA related I was able to find a solution that did not require any programming. Since the solution was challenging and interesting I thought

## Word IF Then Else Rule (Mail Merge) Insert Fields

Previously in the article Word IF Then Else Rule (Mail Merge) I’ve explained how you can use the If Then Rule in Mail Merge. In that article the If Then Else Field would insert a text string based on the result of the comparison. In this article I will

## Word Skip Record If Rule (Mail Merge)

In this article I will explain the Skip Record If Rule used in Mail Merge. – What is it? The Skip Record If Rule compares the value of a field with a certain value. If the comparison returns true, the current record will not be merged. Example: Consider

## Excel Functions and Formulas Sample #1, Split Strings Based on Delimiter

In this article I will provide an example on how you could split a string based on a delimiter character using excel formulas and functions. You can download the workbook for this article here. Jump To: Function Used in this Example Summary Implementation Step 1, Indice Column

## Word, Delete Skip Record If Rule (Mail Merge)

The Skip Record If Field is not visible by default: In order to delete the Skip Record If Field you will have to make it visible first. Step 1: Press Alt + F9: Step 2: Look for the SKIPIF Field: Step 3: Delete it: See

## Excel Formulas and Function, Finding Text Within Another Text, Find()

The function FIND() searches for a specific text expression inside another text and returns the first index which the text was found. You can download the workbook related to this article here. Jump To: Syntax Example 1 Example 2 Syntax: =FIND(Text_to_Find, Text_to_Search_in, Starting_Index) Text_to_Find: The

## Word, Delete Next Record If Rule (Mail Merge)

The Next Record If Field is not visible by default: In order to delete the Next Record If Field you will have to make it visible first. Step 1: Press Alt + F9: Step 2: Look for the NEXTIF Field: Step 3: Delete it:   See also: Word,

## Word IF Then Else Rule (Mail Merge)

In this article I will explain the IF Then Else Rule used in Mail Merge. Note: It is assumed readers are familiar with mail merge before reading this article. – What is it? I’ve previously explained how you can add fields to a document. These

## Excel Functions and Formulas, IF()

In this article I will explain the IF() function. The IF() function receives 3 input parameters. The first input parameter is a logical test. The logical test will either equate to True or False. If the logical test equates to TRUE then the second parameter

## Word, Delete Next Record Rule (Mail Merge)

The Next Record Field is not visible by default: In order to delete the Next Record Field you will have to make it visible first. Step 1: Press Alt + F9: Step 2: Look for the NEXT Field: Step 3: Delete it:   See also: Word, Mail Merge