Find Substring Within a String in Excel : MS Excel Tips

preview_player
Показать описание
Subscribe Now:

Watch More:

Finding substrings within a string in Excel is something that you might want to do if you were working with an element like email addresses. Find a substring within a string in Excel with help from a software expert in this free video clip.

Expert: Brie Clark
Filmmaker: Alexis Guerreros

Series Description: Microsoft Excel is still one of the most advanced spreadsheet creation and maintenance tools on the planet. Get Excel tips with help from a software expert in this free video series.
Рекомендации по теме
Комментарии
Автор

ok..you have a text string of 20 numbers as follows: 02-03-07-09-14-16-25-26-31-33-37-39-40-45-47-52-53-54-69-72, and this column contains 100 or more of these types of numbers, all 20 numbers long but with different sequences of 20 numbers...what function do i use to "comb" down thru the column and tell me each row/instance that has the following substring contained anywhere within it, "02-26-72"?

casst