Split text to columns (or rows) with an Excel formula!
The SPLITTEXT formula splits an Excel value into multiple values based on a delimiter! Great for separating full name into first name and last name. Also great for formatting CSV data. The formula works the same way as the built-in “text to columns” feature, but with the option to separate to rows.
System Requirements: Microsoft Excel and Microsoft Windows.
Download a free 3-day trial:
Review the setup steps and user guide:
Get answers to Frequently Asked Questions: