Did you ever wonder if there was an Excel formula that could split a text into columns or rows? Well, there is now!
Introducing Split Text XL, which provides the SPLITTEXT formula. Use the SPLITTEXT formula to split text to columns or rows by a specified delimiter. The formula works similar to the “Text to Columns” feature in Excel, but also offers the option to split text to rows.
Use Split Text XL to split full names into first and last names, or use it to format CSV data as needed.
Download a free trial of Split Text XL at http://TumblingWave.com today!