---
title: "FIND and SEARCH practice: 5 exercises with answers"
description: "Practice FIND and SEARCH in Excel with LEFT, MID and LEN: split an email at the @, check for a word and count words in a cell."
canonical_url: "https://excelsavvy.com/practice/find-search"
meta:
  "og:description": "Practice FIND and SEARCH in Excel with LEFT, MID and LEN: split an email at the @, check for a word and count words in a cell."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~RklORCBhbmQgU0VBUkNIIHByYWN0aWNlOiA1IGV4ZXJjaXNlcyB3aXRoIGFuc3dlcnM%2Cdescription_~UHJhY3RpY2UgRklORCBhbmQgU0VBUkNIIGluIEV4Y2VsIHdpdGggTEVGVCwgTUlEIGFuZCBMRU46IHNwbGl0IGFuIGVtYWlsIGF0IHRoZSBALCBjaGVjayBmb3IgYSB3b3JkIGFuZCBjb3VudCB3b3JkcyBpbiBhIGNlbGwu%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiRW1haWwiLCJQb3NpdGlvbiBvZiBAIl19LHsibiI6MiwiY2VsbHMiOlsiYW5uYS5iZXJnQG5vcnRod2luZC5jb20iLCIiXX1dLCJ0YXJnZXQiOlsxLDFdfX0%2Cp_Ii9wcmFjdGljZS9maW5kLXNlYXJjaCI%2Cs_rurVi4vSZuLvrGn-.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "FIND and SEARCH practice: 5 exercises with answers"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~RklORCBhbmQgU0VBUkNIIHByYWN0aWNlOiA1IGV4ZXJjaXNlcyB3aXRoIGFuc3dlcnM%2Cdescription_~UHJhY3RpY2UgRklORCBhbmQgU0VBUkNIIGluIEV4Y2VsIHdpdGggTEVGVCwgTUlEIGFuZCBMRU46IHNwbGl0IGFuIGVtYWlsIGF0IHRoZSBALCBjaGVjayBmb3IgYSB3b3JkIGFuZCBjb3VudCB3b3JkcyBpbiBhIGNlbGwu%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiRW1haWwiLCJQb3NpdGlvbiBvZiBAIl19LHsibiI6MiwiY2VsbHMiOlsiYW5uYS5iZXJnQG5vcnRod2luZC5jb20iLCIiXX1dLCJ0YXJnZXQiOlsxLDFdfX0%2Cp_Ii9wcmFjdGljZS9maW5kLXNlYXJjaCI%2Cs_rurVi4vSZuLvrGn-.png"
---

> Index of every page on this site: [llms.txt](https://excelsavvy.com/llms.txt)

# **FIND and SEARCH practice exercises**

Find where a character sits in a text, then use that position with LEFT, MID and LEN to cut text that has no fixed length, like names and email addresses.

[**Start the first exercise**](https://excelsavvy.com/practice/find-search/find-position-of-character)

ISNUMBER(LEN(SUBSTITUTE(

## **How FIND and SEARCH work**

FIND and SEARCH tell you where one text sits inside another. Both take the text to look for, the text to look in, and an optional position to start from. The result is a number, the position of the first matching character, or a #VALUE! error if there is no match. FIND tells capitals from small letters and takes no wildcards. SEARCH ignores case and accepts ? and \* as wildcards.

`**=FIND("@",A2)**` returns 6 for " [**mette@firma.dk**](mailto:mette@firma.dk)". A position on its own isn't much use, so you feed it to LEFT or MID. `**=LEFT(A2,FIND("@",A2)-1)**` returns "mette", the part before the @, because it takes one character fewer than the position of the @.

To check whether a text contains a word, wrap SEARCH in ISNUMBER: `**=ISNUMBER(SEARCH("pro",A2))**` shows TRUE for "ProBook 15" and FALSE for "Basic 15". ISNUMBER turns a position into TRUE and an error into FALSE. Use FIND only when case matters, since `**=FIND("pro",A2)**` misses "ProBook". The exercises below cover finding the @, the name before it, the domain after it, checking for a word and counting the words in a cell.

1. [**1****Find the @ in an email with FIND**In B2, use FIND to get the position of the @ in the email address in A2.](https://excelsavvy.com/practice/find-search/find-position-of-character)
2. [**2****Take the name before the @****Premium**In B2, get the part of the email in A2 before the @. Use LEFT, with FIND to work out how many characters to take.](https://excelsavvy.com/practice/find-search/left-find-text-before-character)
3. [**3****Take the domain after the @****Premium**In B2, get the domain, the part of the email in A2 after the @. Use MID to start one character after the @, and LEN for the number of characters.](https://excelsavvy.com/practice/find-search/mid-find-text-after-character)
4. [**4****Check if a text contains a word****Premium**In B2, show TRUE if the product name in A2 contains "pro" in any case. Use SEARCH inside ISNUMBER.](https://excelsavvy.com/practice/find-search/search-isnumber-contains)
5. [**5****Count the words in a cell****Premium**In B2, count the words in A2. There is one more word than there are spaces, and LEN(A2) minus the length without spaces, LEN(SUBSTITUTE(A2," ","")), is the number of spaces.](https://excelsavvy.com/practice/find-search/count-words-in-cell)

## **Functions in this topic**

- [**ISNUMBER**](https://excelsavvy.com/functions/isnumber)
- [**LEN**](https://excelsavvy.com/functions/len)
- [**SUBSTITUTE**](https://excelsavvy.com/functions/substitute)

## **Read the guide**

- [**Excel IF formulas: from one condition to many**](https://excelsavvy.com/learn/excel-if-function)
- [**How to clean data in Excel with formulas**](https://excelsavvy.com/learn/clean-data-in-excel)
- [**Line breaks in Excel: a new line in a cell, with a formula and gone again**](https://excelsavvy.com/learn/line-break-in-excel)
- [**Excel customer data: free practice file with tasks and answers**](https://excelsavvy.com/learn/excel-customer-data)

## **Questions**

<details>

<summary>

### How do I check if a cell contains certain text in Excel?

</summary>

Combine IF, ISNUMBER and SEARCH: =IF(ISNUMBER(SEARCH("pro",A2)),"Yes","No"). It finds "pro" anywhere in the cell, in any case. A shorter option is =COUNTIF(A2,"\*pro\*"), which returns 1 when the cell contains the text and 0 when it doesn't. The stars are wildcards for any characters before and after.

</details>

<details>

<summary>

### Why does FIND return #VALUE! in Excel?

</summary>

The text you look for wasn't found. Common causes are a different capitalization, since FIND is case-sensitive, a typo, or an extra space. A start position larger than the text length gives the same error. Switch to SEARCH if case shouldn't matter, or wrap it: =IFERROR(FIND("@",A2),0) returns 0 when there is no @.

</details>

<details>

<summary>

### How do I find the second occurrence of a character in Excel?

</summary>

Use the start position argument to begin just after the first match. =FIND(" ",A2,FIND(" ",A2)+1) returns the position of the second space. The inner FIND locates the first space, and adding 1 makes the outer FIND start after it. Nest it once more to find the third space.

</details>

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://excelsavvy.com/#identity","@type":"Organization","name":"ExcelSavvy","url":"https://excelsavvy.com/","logo":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/#website","@type":"WebSite","inLanguage":"en-US","name":"ExcelSavvy","url":"https://excelsavvy.com/","alternateName":["Excel Savvy","ExcelSavvy.com","PracticeExcel","Practice Excel Online"],"publisher":{"@id":"https://excelsavvy.com/#identity"},"workTranslation":[{"@id":"https://excelopgaver.dk/#website"},{"@id":"https://excelpraxis.de/#website"}]},{"@id":"https://excelsavvy.com/practice/find-search#webpage","description":"Practice FIND and SEARCH in Excel with LEFT, MID and LEN: split an email at the @, check for a word and count words in a cell.","name":"FIND and SEARCH practice: 5 exercises with answers","url":"https://excelsavvy.com/practice/find-search","@type":["WebPage","CollectionPage","FAQPage"],"breadcrumb":{"@id":"https://excelsavvy.com/practice/find-search#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"mainEntity":[{"@id":"https://excelsavvy.com/practice/find-search#/schema/question/1"},{"@id":"https://excelsavvy.com/practice/find-search#/schema/question/2"},{"@id":"https://excelsavvy.com/practice/find-search#/schema/question/3"}],"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/practice/find-search"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/practice/find-search#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://excelsavvy.com","position":1},{"@type":"ListItem","name":"Excel practice exercises","item":"https://excelsavvy.com/practice","position":2},{"@type":"ListItem","name":"FIND and SEARCH practice: 5 exercises with answers","position":3}]},{"@id":"https://excelsavvy.com/practice/find-search#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"How do I check if a cell contains certain text in Excel?","acceptedAnswer":{"@type":"Answer","text":"Combine IF, ISNUMBER and SEARCH: =IF(ISNUMBER(SEARCH(\"pro\",A2)),\"Yes\",\"No\"). It finds \"pro\" anywhere in the cell, in any case. A shorter option is =COUNTIF(A2,\"*pro*\"), which returns 1 when the cell contains the text and 0 when it doesn't. The stars are wildcards for any characters before and after."}},{"@id":"https://excelsavvy.com/practice/find-search#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"Why does FIND return #VALUE! in Excel?","acceptedAnswer":{"@type":"Answer","text":"The text you look for wasn't found. Common causes are a different capitalization, since FIND is case-sensitive, a typo, or an extra space. A start position larger than the text length gives the same error. Switch to SEARCH if case shouldn't matter, or wrap it: =IFERROR(FIND(\"@\",A2),0) returns 0 when there is no @."}},{"@id":"https://excelsavvy.com/practice/find-search#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"How do I find the second occurrence of a character in Excel?","acceptedAnswer":{"@type":"Answer","text":"Use the start position argument to begin just after the first match. =FIND(\" \",A2,FIND(\" \",A2)+1) returns the position of the second space. The inner FIND locates the first space, and adding 1 makes the outer FIND start after it. Nest it once more to find the third space."}},{"@id":"https://excelsavvy.com/#logo","@type":"ImageObject","caption":"ExcelSavvy","contentUrl":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3","inLanguage":"en-US","url":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3"}]}
```

## Sitemap

See the full [sitemap](https://excelsavvy.com/sitemap.md) for all pages.
