Giá Miễn phí
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.
Chức năng của ứng dụng
Khi bạn sử dụng, ứng dụng này
- Có thể đọc và thực hiện các thay đổi cho tài liệu của bạn
- Có thể gửi dữ liệu qua Internet
Xem nhanh
Các ứng dụng khác từ 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 điều khoản sử dụng and chính sách về quyền riêng tư and understand that the rights to use this product do not come from Microsoft, unless Microsoft is the provider. Use of điều khoản is governed by separate quyền riêng tư and {4}.