Advanced Excel Formulas to Split Names, Addresses and Phones

We use advanced excel formulas with custom vba programmed functions to split string data into columns. For example to split string with names and phones to First Name, Last Name and Phone columns: [swf:http://xlbin.com/wp-content/uploads/2012/02/aefsnp.swf 595 359]
http://xlbin.com/wp-content/uploads/2012/02/aefsnp.swf

Advanced excel formulas also can be used to split addresses.

One of our pdf to excel data conversion job where advanced exel formulas were used to split names to First Name and Last Name columns and addresses to Address Number 1, Address Number 2, City, State, Zip Code columns: