You can click to jump to the corresponding formula cell in worksheet immediately.
Now all matched cells are listed in the Super Find pane. 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.Ģ.3) Select Text contains option from the Type drop-down list.Ģ.4) Enter VLOOKUP into the Value text box.Ģ.5) Click the Find button. See screenshot:Ģ.1) Click the button to enable the Find in formulas option Ģ.2) Specify the finding range from the Within drop-down list. Click Kutools > Find > Super Find to open the Super Find pane in the worksheet. Supposing, you want to find and select all cells which contain VLOOKUP text in the formula, you can do as follows to achieve it.ġ.
More than 300 powerful features Works with OfficeĢ007-2019 and 365 Supports all languages Easy deploying in your enterprise or organization.įind and select specific cells contain certain text in formulas.Super Filter: Create advanced filter schemes and apply to any sheets Sort by week, day, frequency and more Filter by bold, formulas, comment.Paste Skipping Hidden/Filtered Rows Count And Sum by Background Color Send Personalized Emails to Multiple Recipients in Bulk.
Split Tools: Split Data into Multiple Sheets Based on Value One Workbook to Multiple Excel, PDF or CSV Files One Column to Multiple Columns.Merge Tools: Multiple Workbooks and Sheets into One Merge Multiple Cells/Rows/Columns Without Losing Data Merge Duplicate Rows and Sum.More than 20 text features: Extract Number from Text String Extract or Remove Part of Texts Convert Numbers and Currencies to English Words.Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
That means the extracted results are dynamic, and they can update automatically based on the original cells in the specified range.Įnhance the repairing feature to solve the problem of loading failure.ġ)Fixed: Some minor bugs occur when applying the AutoText feature in the Navigation Pane.Ģ)Fixed: Some bugs occur when looking for comments with username in the Super Find Pane.ģ)Fixed: Some formula errors come out when creating dynamic drop-down list in non-English environments.Ĥ)Fixed: The Average line added by the Add Line to Chart tool cannot update automatically.ĥ)Fixed: Some minor bugs occur in the Super Filter Pane.Ħ)Fixed: When adding OneDrive folders in the Combine Worksheets dialog, their subfolders are ignored.ħ)Fixed: Some features cannot save the custom-defined colors.Ĩ)Fixed: Barcodes cannot be inserted due to blank or special characters existing in the worksheet names.ĩ)Fixed: In the latest Office 365, the Export Range to File feature cannot export a selection to simple HTML file because the total number of characters in some cells of the selection is greater than 255.ġ0)Fixed: The Work Area feature probably cannot work in Excel 2013 and later versions.ġ1)Fixed: The Reading Layout feature may cause lockup when copying and pasting to other worksheets in some cases.ġ2)Fixed: The Monitor Precedents and Dependents feature lead to copying and pasting failures in some situations.ġ3)Fixed: OneDrive folders cannot be found in some situations.Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80% In the latest version, the Extract Text feature has been improved greatly to handle most of extracting needs:ġ) Extract the first N characters, says extract the first 10 characters from the left of each cell in the specified range Ģ) Extract the last N characters, says extract the last 6 characters from the right of each cell in the specified range ģ) Extract characters in the specified position range, says extract from the 5th character to the 12th character from each cell in the specified range Ĥ) Extract characters before a given text, says extract all characters before the first blank from each cell in the specified range ĥ) Extract characters after a given text, says extract all characters after the first blank from each cell in the specified range Ħ) Extract all numbers from each cell in the specified range.ħ) The feature supports to use formulas to extract the characters.