Cookies help us deliver our services. By using our services, you agree to our use of cookies.
Log in
x
or
x
x
Register
x

or

Quickly find specific text string only in cell value in Excel

The Find function in Excel helps users to find cells which contain partial text or certain value in a selection, the active sheet or the whole workbook. However, if you want to find cells based on other various criteria across selected worksheets or all opened workbooks, what can you do? Here, you can try the Super Find utility of Kutools for Excel to quickly get it done.

Find and select specific cells contain a partial/certain text string

Find and select specific cells based on certain text length

Find and select cells contain all uppercase or lowercase


Find and select specific cells contain a partial/certain text string

If you want to find and select specific cells which contain partial text or a certain value, please do as follows.

1. Click Kutools > Super Find. See screenshot:

2. In the opening Super Find pane, please do the following operations:

2.1) Click button to enable the Find in text strings option;

2.2) Specify the finding scope from the Within drop-down list. Here we provide five options which include Selection, Active sheet, Selected worksheets, Active workbook as well as All workbooks for you, you can select any one based on your needs.

2.3) Select Text contains option from the Type drop-down list.

2.4) Enter the partial text or certain value you will find cells based on into the Value text box.

2.5) Click the Find button. See screenshot:

3. Then all cells that contain the specific partial text or value are listed in the Result list box. You can click the item to shift to that cell in worksheet immediately.


Find and select specific cells based on certain text length

The Super Find utility can also help you to find cells based on certain text length in Excel. Please do as follows.

1. Click Kutools > Super Find. See screenshot:

2. In the opening Super Find pane, you need to:

2.1) Enable the Find in text strings option by clicking button ;

2.2) Specify the finding scope from the Within drop-down list. Here have five options which include Selection, Active sheet, Selected worksheets, Active workbook as well as All workbooks for you, you can select any one based on your needs.

2.3) Select a text length option based on your needs from the Type drop-down list.

2.4) Enter the number of text length into the Value text box.

2.5) Click the Find button. See screenshot:

3. You can see all cells that the text length are greater than 10 are listed in the Result box. Click on any result will shift to that cell in the worksheet at once.


Find and select cells contain all uppercase or lowercase

If you want to find all uppercase or lowercase text string cells in Excel, the Super Find utility also can do you a favor.v

1. Click Kutools > Super Find to open the Super Find pane.

2. In the Super Find pane, you need to do as following screenshot shown.

2.1) Enable the Find in text strings feature by clicking button;

2.2) Specify the finding scope from the Within drop-down list. Here have five options which include Selection, Active sheet, Selected worksheets, Active workbook as well as All workbooks for you, you can select any one based on your needs.

2.3) Select Text is uppercase or Text is lowercase from the Type drop-down list.

2.4) Click the Find button.

Then all lowercase cells are found out and listed in the Result box. You can click on any result to shift to that cell in the worksheet at once.

Notes:

1. If you have specified the Selection or Active sheet option in the Within drop-down list, you can click the Select button to select all listed results at the same time. If the Selected worksheets, Active workbook or All workbooks option has been selected, the Select button will not available.

2. This Super Find feature allows you to find specific text among text strings, comments, formulas, and hyperlinks at the same time in Excel. See screenshot:


Demo: Find in test strings

Kutools for Excel includes more than 300 handy Excel tools. Free to try with no limitation in 60 days. Download the free trial now!


Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2019, 2016, 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013, 2016, 2019 and 365, as if it were Office 2000 and 2003.

Kutools for Excel

The functionality described above is just one of 300 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.