This problem can be solved with the LEFT function, as explained below.

LEFT function

TheLEFT functionextracts a given number of characters from the left side of a text string.

Also note thenum_charsargument is set to 3 above, but must be modified according to the situation.

Excel formula: Cell ends with

EXACT will only return TRUE whentext1andtext2are exactly the same, taking into account case.

The second formula returns TRUE because “XYZ"doesequal “XYZ” taking into account case.

This means you could’t use COUNTIF to test values in an array returned by another operation.

Excel formula: Cell contains specific text

For example, =LEFT(“apple”,3) returns “app”.

Excel formula: Cell contains one of many things

Excel formula: Categorize text with keywords

Excel formula: Highlight cells that contain

Excel formula: Value exists in a range

Excel formula: Count cells that contain either x or y

Excel LEFT function

Excel EXACT function

Excel COUNTIF function

Article image