Please enable JavaScript to view the comments powered by Disqus.

IF(...F4="","",MID(...F4,SEARCH(...", ",F4)+1,11))

search function

Finding Phone number using search function

Used Functions

Category: Logical

Specifies a logical test to perform


IF(Something is True, then do something, otherwise do something else)

Category: Text

Returns a specific number of characters from a text string starting at the position you specify


MID(text, start_num, num_chars)

Lets chat on this