Function Problems

Find a Name Within Text in Excel or an Access Field

Adam DavisAdam Davis Nov 22, 2026 868 views

Question details

Determine whether a representative's name appears anywhere in a cell or database field containing multiple names.

Find a Name Within Text in Excel or an Access Field
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.
Before you start

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.

Solution 1Recommended

Search a combined field with Access query criteria

Use this method to return Access records where the combined text contains the representative's name.

1
Open the query in Design View

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.

2
Add the search criteria

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].

3
Run and check the query

Select Run on the Query Design ribbon and review the matching records. The asterisks allow text before and after the representative's name.

Search a combined field with Access query criteria
Check the wildcard mode: The asterisk is the usual Access query wildcard. If the database uses ANSI-92 wildcard syntax, use % instead: Like "%" & [Edge Rep] & "%".
WPS Spreadsheets

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. 1. Open the spreadsheet: Open WPS Office, select Spreadsheets, and open the workbook containing the names.
  2. 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. 3. Enter the formula: Select an empty cell and enter =IF(A2="","",ISNUMBER(SEARCH(A2,B2))), adjusting the references if needed.
  4. 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.
Search combined names without restructuring the worksheetCompatible with Microsoft Excel XLSX and XLS filesCopy the formula down to check multiple rowsUse a familiar spreadsheet interface
microsoft office alternative - wps office

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.