filmov
tv
Excel - Identify Text Types with the FIND Function

Показать описание
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.