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.
1 Each year, termites and similar pests cause an estimated $30 billion in damage to crops and man-made structures in the U.S. 2  A homeowner who discovers termite damage will spend an average of $3,000 to repair the damage.n other cases, termite damage can cost thousands of dollars. In rare cases, homes are demolished because the termite damage is so extensive. The annual cost of termite damage and control measures in the U.S. is estimated at $5 billion.