If you can use VBA then you can make use of the Split() function. Here's a User-Defined Function (UDF) that you can use in a cell. It splits on your choice of character and returns the nth element of the split list.
Once detected, the average termite control service cost ranges between $200 and $3,000. See how to rid of all home termites once and for all.
Termite Extermination Average Costs. 1  Pest control companies typically provide a free termite inspection to go along with an estimate. 2  Termite extermination starts at $500 to $1,500 but can cost as much as $2,000 to $4,000 depending on the severity of the problem and the solutions implemented.n inspection will uncover whether or not you have a termite problem and if so, how the insects should be dealt with. The cost of termite extermination depends on the termite species, the structure size, and the pest control method(s) used.