---
schema_version: "1"
id: 9503a81595af3444ab607130175aeb660ec3d54dade82d79846efb103352f144
title: FIND
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/platform/264-0-0/customize_functions_find.md
canonical_url: https://help.salesforce.com/s/articleView?id=platform.customize_functions_find.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: e0f62ff83d22a55eeef6d1eefe5fee1ddb2cd3d7777b3963584b895811cf4ce2
description: Returns the position of a string within a string of text represented as a number.
products:
  - Salesforce Platform
  - Security
release: "264"
---
# FIND

Returns the position of a string within a string of text represented as a number.

## Use

`FIND(search_text, text[, start_num])` and replace search\_text with the string you want to find, replace text with the field or expression you want to search, and replace start\_num with the number of the character from which to start searching from left to right.

## Tips

- Be sure to remove the brackets, \[ and \], from your formula before validating it.
- If the field referenced in your text parameter is blank, the formula field displays 0.
- Your search\_text parameter is case-sensitive and can't contain any wildcard characters.
- If your search doesn't return any results, a 0 displays in the field.
- The start\_num parameter is optional. If you don't enter a start\_num value, the formula uses the value one, or the first character in the string.
- If your start\_num isn't greater than zero, a 0 displays in the field.
- If your start\_num is greater than the length of the text, a 0 displays in the field.
- When entering your start\_num parameter, remember that some fields like the Website field are unique because a http:// is automatically appended to the beginning of the text you enter.
- The first character in a string is designated as one rather than zero.

![Street Address Example ](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-platform-extend_click-264-0-0-production-enus/5f7d9219-b7b1-4552-8891-f1aba9b289fc/images/icon_example.png)

Street Address Example

`FIND(" ", Street)` returns the character position of the first space in the Street field. You can use this number to find out the length of the street address as a means of separating a street address from a street name in an address field.

![Deriving Website Addresses Example](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-platform-extend_click-264-0-0-production-enus/5f7d9219-b7b1-4552-8891-f1aba9b289fc/images/icon_example.png)

Deriving Website Addresses Example

`SUBSTITUTE(Email, LEFT(Email, FIND("@", Email)), "www.")` finds the location of the @ sign in a person's email address to determine the length of text to replace with a “www.” as a means of deriving their website address.