Pull phone numbers out of cell
Posted on 2014-07-25
I have a column of data that has memo's in them. Short paragraphs are in each cell.
I would like to try to pull out any phone number listed in the memo in the next column. The phone numbers can be of any format ie: xxx.xxx.xxxx or (xxx) xxx-xxxx or xxxxxxxxxx.
If easier, I can write something for each format. For example pull out any phone number in the format (XXX) XXX-XXXX. Then another for any in the format XXX.XXX.XXXX. Then another for XXX-XXX-XXXX. Then one for XXX-XXX-XXXX.
Any way to make that happen? This could save me HOURS of time!