If you want to select the entire column, click Expand selection.Select a cell or column with the records you want to split, and you will see its address in this field.Use the Split by Strings option to separate values by a combination of characters.Ĭlick the Split Text icon on the Ablebits Data tab, in the Text group, and select Split by Strings:įine-tune the splitting options in the tool pane: Excel doesn't let you cancel changes made by add-ins, which is why we recommend selecting the Back up this worksheet option.Decide how to split your cells: by columns or by rows:.If we tick At the end, the result will be ab. If we tick At the beginning, we'll have ab |. If you want to preserve delimiters in the split records, select the Keep delimiters in resulting cells option and then choose whether you want to have them At the beginning or At the end of the cell contents.įor instance, if we have "ab.cd.ef" in a cell, split it by "." and do not check this box, we will get ab | cd | ef.If the values to be split are divided by several successive symbols and you want the add-in to process them all as one delimiter, select the Treat consecutive delimiters as one option.Also, you can enter any other character into the Custom field. The values you want to split may be separated by standard delimiters, such as comma, space, semicolon, and/or line break.The tool can split only one column at a time.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |