Advanced Excel Formulas to Split Names, Addresses and Other Data

We use advanced excel formulas with user defined functions to split string data into appropriate columns.

For example, you can se how we split records with full name and phone number in one column into First Name, Last Name and Phone columns:

[swf:http://xlbin.com/wp-content/uploads/2012/02/aefsnp.swf 595 359]