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 A chemical is sprayed in areas where termites have been seen and other areas that may be necessary. 2  These average between $1300-$1500 per treatment. 3  If you do it yourself you can easily save up to 80%. 4  We sell the exact same chemicals that termite companies use, like Termidor termiticide or Dominion 2L termiticide. You can buy termite baits from us and do it yourself for much cheaper. 2  Chemical treatments are usually charged by the linear foot, not by the square footage of your home. 3  The average per foot is about $4-$16.