---
title: "FIND and SEARCH practice exercises | PracticeExcel"
description: "Practice FIND and SEARCH in a live spreadsheet, and combine them with LEFT, MID and LEN."
canonical_url: "https://practiceexcelonline.com/practice/find-search"
locale: en
meta:
  "og:description": "Practice FIND and SEARCH in a live spreadsheet, and combine them with LEFT, MID and LEN."
  "og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_FIND%2Band%2BSEARCH%2Bpractice%2Bexercises%2Cdescription_~UHJhY3RpY2UgRklORCBhbmQgU0VBUkNIIGluIGEgbGl2ZSBzcHJlYWRzaGVldCwgYW5kIGNvbWJpbmUgdGhlbSB3aXRoIExFRlQsIE1JRCBhbmQgTEVOLg%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiRW1haWwiLCJQb3NpdGlvbiBvZiBAIl19LHsibiI6MiwiY2VsbHMiOlsiYW5uYS5iZXJnQG5vcnRod2luZC5jb20iLCIiXX1dLCJ0YXJnZXQiOlsxLDFdfX0%2Cp_Ii9wcmFjdGljZS9maW5kLXNlYXJjaCI%2Cs_1VRXL0tFk12oHjoa.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "FIND and SEARCH practice exercises | PracticeExcel"
  "twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_FIND%2Band%2BSEARCH%2Bpractice%2Bexercises%2Cdescription_~UHJhY3RpY2UgRklORCBhbmQgU0VBUkNIIGluIGEgbGl2ZSBzcHJlYWRzaGVldCwgYW5kIGNvbWJpbmUgdGhlbSB3aXRoIExFRlQsIE1JRCBhbmQgTEVOLg%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiRW1haWwiLCJQb3NpdGlvbiBvZiBAIl19LHsibiI6MiwiY2VsbHMiOlsiYW5uYS5iZXJnQG5vcnRod2luZC5jb20iLCIiXX1dLCJ0YXJnZXQiOlsxLDFdfX0%2Cp_Ii9wcmFjdGljZS9maW5kLXNlYXJjaCI%2Cs_1VRXL0tFk12oHjoa.png"
---

> Index of every page on this site: [llms.txt](https://practiceexcelonline.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://practiceexcelonline.com/practice/find-search/find-position-of-character)

ISNUMBER(LEN(SUBSTITUTE(

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://practiceexcelonline.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://practiceexcelonline.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://practiceexcelonline.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://practiceexcelonline.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://practiceexcelonline.com/practice/find-search/count-words-in-cell)

## **Functions in this topic**

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

## **Read the guide**

- [**Excel IF formulas: from one condition to many**](https://practiceexcelonline.com/learn/excel-if-function)
- [**How to clean data in Excel with formulas**](https://practiceexcelonline.com/learn/clean-data-in-excel)

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://practiceexcelonline.com/#identity","@type":"Organization","name":"PracticeExcel","url":"https://practiceexcelonline.com/","logo":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/#website","@type":"WebSite","inLanguage":"en-US","name":"PracticeExcel","url":"https://practiceexcelonline.com/","alternateName":["Practice Excel Online","PracticeExcelOnline.com"],"publisher":{"@id":"https://practiceexcelonline.com/#identity"},"workTranslation":{"@id":"https://excelopgaver.dk/#website"}},{"@id":"https://practiceexcelonline.com/practice/find-search#webpage","description":"Practice FIND and SEARCH in a live spreadsheet, and combine them with LEFT, MID and LEN.","name":"FIND and SEARCH practice exercises","url":"https://practiceexcelonline.com/practice/find-search","@type":["WebPage","CollectionPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/practice/find-search#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/practice/find-search"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/practice/find-search#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://practiceexcelonline.com","position":1},{"@type":"ListItem","name":"Excel practice exercises","item":"https://practiceexcelonline.com/practice","position":2},{"@type":"ListItem","name":"FIND and SEARCH practice exercises","position":3}]},{"@id":"https://practiceexcelonline.com/#logo","@type":"ImageObject","caption":"PracticeExcel","contentUrl":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png"}]}
```

## Sitemap

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