Excel - Identify Text Types with the FIND Function

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

Problem: You have a column of data in Excel that mixes different types of text together, for example email addresses and phone numbers. How do you write a formula to label which is which?

Solution: Use the FIND function, with some help from ISERROR.
Рекомендации по теме
visit shbcf.ru