Pricing Free
Split text into separate columns by any characters
Whenever you want to pull text from a cell into different columns, this add-in will be the perfect online tool.
It allows you to split values by any standard delimiters like spaces and line breaks, or use custom separators you have in your data.
Once you select the column with text and choose your delimiters in the add-in pane, click Split to get new columns with the results to the right of your data. If you have enough blanks there, the add-in will use them and keep your table clear.
You can divide the values by any number of delimiters at once. If these characters follow one another, you can avoid adding an extra column by checking the option to “Treat consecutive delimiters as one”.
Please note that this add-in does not support Excel 2013. It will split your records in Excel online or Excel 2016 in a flash.
App capabilities
When this app is used, it
- Can read and make changes to your document
- Can send data over the Internet
At a glance
Other apps from Add-in Express
Shared Email TemplatesAdd-in Express
OutlookShared templates for Outlook emails, calendar events, and signatures + mail merge
OutlookApplicable to:Outlook
OutlookNaN out of 4
AttachmentsAdd-in ExpressOutlookQuickly get all files used in an email conversation.
OutlookApplicable to:Outlook
OutlookNaN out of 4
Duplicate RemoverAdd-in Express
ExcelFind duplicate or unique records in your sheet; choose one of 6 ways to deal with the results.
ExcelApplicable to:Excel
ExcelNaN out of 4
Advanced Find and ReplaceAdd-in ExpressExcelQuickly find and replace values or formulas in all selected sheets at once
ExcelApplicable to:Excel
ExcelNaN out of 4
By getting this product, I give Microsoft permission to use or share my account information so that the provider can contact me regarding this product and related products. I agree to the provider's terms of use and privacy policy and understand that the rights to use this product do not come from Microsoft, unless Microsoft is the provider. Use of AppSource is governed by separate terms and privacy.