MID Function Need to extract a specific part of a text string? The MID function returns a substring from the middle of a text string, based on the starting point and length you specify. Here’s how to use it: ❶ Open Excel or Google Sheets. ❷ Enter =MID(text, start_num, num_chars) in any cell. ❸ Instantly extract the desired portion of text. ✂️ Fine-tune your text data with the MID function! #excel #spreadsheets #googlesheets
INDIRECT function of Excel is used to give reference to the cell, cell range, any named range, work sheets or workbook. In simple words INDIRECT function is used to refer the cells, cell range of different work sheets or workbook in any formula and converts the text string into a valid cell reference. #excel #vba #finance #accounting #financialmodeling #banking #money #entrepreneur
SUBSTITUTE Function Need to replace specific text within a string? The SUBSTITUTE function swaps out one text string for another, making edits to your data quick and easy. Here’s how to use it: ❶ Open Excel or Google Sheets. ❷ Enter =SUBSTITUTE(text, old_text, new_text) in any cell. ❸ Instantly replace the text you want. 🔄 Simplify text replacement with the SUBSTITUTE function! #excel #spreadsheets #googlesheets
Syntax For Excel FIND Function
