SUBSTITUTE function - Microsoft Support
This article describes the formula syntax and usage of the SUBSTITUTE function in Microsoft Excel. Description. Substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string. Syntax.
REPLACE, REPLACEB functions - Microsoft Support
REPLACEB (old_text, start_num, num_bytes, new_text) The REPLACE and REPLACEB function syntax has the following arguments: Old_text Required. Text in which you want to replace some characters. Start_num Required. The position of the character in old_text that you want to replace with new_text. Num_chars Required.
Check if a cell contains text (case-insensitive) - Microsoft Support
Find cells that contain text. Follow these steps to locate cells containing specific text: Select the range of cells that you want to search. To search the entire worksheet, click any cell. On the Home tab, in the Editing group, click Find & Select, and then click Find.
Find or replace text and numbers on a worksheet
Use the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string. You can either locate the search item for reference, or you can replace it with something else.
MID, MIDB functions - Microsoft Support
In Excel, the MID and MIDB functions return the specific number of characters in a string starting at the position you specify, based on the number of characters or bytes you specify.
REGEXEXTRACT Function - Microsoft Support
The REGEXEXTRACT function allows you to extract text from a string based on a supplied regular expression. You can extract the first match, all matches or capturing groups from the first match.
Combine text and numbers - Microsoft Support
In Excel, there are several ways to combine text and numbers. Use a number format to display text before or after a number in a cell. If a column that you want to sort contains both numbers and text—such as Product #15, Product #100, Product #200—it may not sort as you expect.
TEXT function - Microsoft Support
The TEXT function lets you change the way a number appears by applying formatting to it with format codes. It's useful in situations where you want to display numbers in a more readable format, or you want to combine numbers with text or symbols.
CELL function - Microsoft Support
The CELL function syntax has the following arguments: info_type values. The following list describes the text values that can be used for the info_type argument. These values must be entered in the CELL function with quotes (" "). CELL format codes.
VALUETOTEXT function - Microsoft Support
The VALUETOTEXT function returns text from any specified value. It passes text values unchanged, and converts non-text values to text. Syntax. VALUETOTEXT (value, [format]) The VALUETOTEXT function syntax has the following arguments. Note: If format is anything other than 0 or 1, VALUETOTEXT returns the #VALUE! error value. Examples.
Python in Excel DataFrames - Microsoft Support
In Python, a DataFrame is an object in the pandas library. The pandas library is a core library used by Python in Excel, and DataFrame objects are a key structure for analyzing data with Python in Excel. Note: Python in Excel uses a DataFrame as the default object for two-dimensional ranges.