How to extract text from a middle of a cell in Google Sheets or Excel using MID and FIND functions

Описание к видео How to extract text from a middle of a cell in Google Sheets or Excel using MID and FIND functions

Sometimes you have a long list of data in a column and you want to pull out a specific string of characters in the cell and put the output in another column. This episode dives into the nested formula using MID() and FIND() to pull out just the data you need from a cell that contains a lot of data.

Intro - 0:00
The MID() function - 0:13
The FIND() function - 2:00
Using Text-to-Columns - 11:27

👉 Copy the Google Sheet: https://docs.google.com/spreadsheets/...
👉 Subscribe to Dear Analyst: https://podcasts.apple.com/us/podcast...
👉 Original blog post for this podcast episode: https://www.thekeycuts.com/dear-analy... in a new tab)

Комментарии

Информация по комментариям в разработке

Похожие видео