I have the following data in column B. I want a universal formula in Col c to change what is in Col B as noted for each row.
Any ideas?
Book2 | ||||||
---|---|---|---|---|---|---|
B | C | D | E | |||
4 | S:Cel:785-685-7505 Annie:Cel:785-685-4804 | S:(785) 685-7505 Annie:(665)685-4804 | ||||
5 | G:Cel:785-685-5954 | G:(785)685-5954 | ||||
6 | Jo:Cel:785-686-4600 | Jo:(785)686-4600 | ||||
7 | Jo:753-937-3839 K:Cel:785-787-7676 S:Cel:837-787-7749 | Jo:(753)937-3839 K:(785)787-7676 S:(837)787-7749 | ||||
Sheet1 |
Any ideas?