Power Tools provides you with various utilities to speed up most of your daily tasks. The instruments from the Split group will help you bring the text from one set of selected columns or rows into several different columns/rows using any character or a string as a delimiter, or divide text at the selected places. The Text group also features these tools.
If you split cells formatted as dates, time, currencies, etc., Google Sheets may change the format of the resulting cells according to their new contents.
The first group lets you split up a column at each occurrence of the delimiters you pick or enter:
If you use a custom separator for the values, select the Custom option and enter your delimiter in the field.
When it is difficult to distinguish a delimiter, dividing text by fixed length is the only way to process data further. With this tool at hand, it is easy to split text into strings of the desired length:
Responses
Hello, after splitting the cells to multiple rows is there a way to then copy all the rest of the text to these multiple rows. For example, there are 4 names in cell A8. I want each name to be in a different row (B8, C8, D8, E8) and then all the information from cells A1-A7 to populate down from row A to row E. thank you!
Hello RT,
Thank you for your question. It looks like Fill Blank Cells is what you need. If, however, this is not what you need, please send an email to support@ablebits.com.
How can i split text but not copy the formatting over as well?
Hello Gary,
Thank you for your question. Please note that our add-on works the same way as Google, i.e. when you insert a column on the right it will automatically pick up the formatting of the left column. For sure, we will keep this case as an idea for improvement.
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!