Find a Name Within Text in Excel or an Access Field
Question details
Determine whether a representative's name appears anywhere in a cell or database field containing multiple names.

- Product
- Microsoft Excel and Microsoft Access
- Device & OS
- not provided
- Scenario
- A user needs to compare a representative's name with a combined text field without changing the existing data structure.
- Observed behavior
- The search should identify cells or records where the representative's name occurs within the combined text.
Identify the field or cell containing the representative's name and the one containing the combined names. In Access, make sure both fields are available in the query.
Search a combined field with Access query criteria
Use this method to return Access records where the combined text contains the representative's name.
In Access, right-click the query in the Navigation Pane and select Design View. Add the table or tables containing the combined text field and Edge Rep field.
Add the combined text field to the query grid. In its Criteria row, enter Like "*" & [Edge Rep] & "*". If the field name is ambiguous, use the qualified reference, such as [Audit Sales Rep Table].[Edge Rep].
Select Run on the Query Design ribbon and review the matching records. The asterisks allow text before and after the representative's name.

Check for a name inside an Excel cell
Use a formula when the representative's name and the combined names are in spreadsheet cells.
Find names in spreadsheet text with WPS Spreadsheets
Use a SEARCH formula in WPS Spreadsheets to check whether a representative's name appears in a cell containing multiple names.
- 1. Open the spreadsheet: Open WPS Office, select Spreadsheets, and open the workbook containing the names.
- 2. Check the cell references: Identify the cell with the representative's name and the cell with the combined names; for example, A2 and B2.
- 3. Enter the formula: Select an empty cell and enter =IF(A2="","",ISNUMBER(SEARCH(A2,B2))), adjusting the references if needed.
- 4. Check additional rows: Drag the formula cell's fill handle down to apply it to other rows, then review the TRUE and FALSE results.

Frequently Asked Questions
Why did my Access query using percent signs return no results?
The query may be using the usual Access wildcard syntax, where * matches any sequence of characters. In the combined field's Criteria row, try Like "*" & [Edge Rep] & "*". Databases using ANSI-92 syntax use % instead.
Is the Excel SEARCH formula case-sensitive?
No. SEARCH ignores case, so it can find a name regardless of capitalization. Use FIND in place of SEARCH if the comparison must be case-sensitive.
Will this search match a name inside a longer name?
Yes. Both the Access wildcard criteria and the spreadsheet SEARCH formula look for text anywhere in the field or cell. Review matches or use a delimiter-aware approach if you need exact separate names.
Do I have to split the names into separate fields first?
No. These searches work with the existing combined text. If you can redesign the database later, storing names as separate related records makes exact matching more reliable.




