Google-sheets – I accidentally clicked “split text to columns” in Data Function

google sheets

I accidentally clicked "split text to columns" using the Data function for one of my cells in a Google Sheet I am working on. How do I return text to how I originally entered it?

Best Answer

If you cannot undo and there are not a lot of changes in the file, you can select File->See revision history and get the edit saved prior to the split.

If neither of these work, you can use get it manually via this formula, modified to meet you range and separator:

=CONCATENATE(H3, " ", J3, " ", K3, " ", L3)

And then Copy the contents of that cell to your clipboard and Past special->Paste values only to get the string back.

Related Solutions

Google Sheets – How to Split Content into Multiple Rows and Columns

Sounds like the =SPLIT function would do what you need. Given that A1 contains the text 1 coffeeextradark 240gr, then

=SPLIT(A1, " ")

^{(notice the space between the quotation marks)}

will split the text into three cells:

1 | coffeeextradark | 240gr

Google-sheets – Split text with Google Sheets

You can use a quite pragmatic approach to reach your goal.

Formula

=ARRAYFORMULA(
   SPLIT(                        // string
     REGEXREPLACE(
       A1:A4,                    // text
       "[users,<=>compani]",     // regular_expression
       ""                        // replacement
     ),                          
   " ")                          // delimiter
 )

copy/paste
=ARRAYFORMULA(SPLIT(REGEXREPLACE(A1:A4, "[users,<=>compani]",""), " "))

Screenshot

enter image description here

Explained

The regular_expression is cleaning up the string, in preparation for the SPLIT. The replacement is simply set to contain an empty string. The result, yields a string that contains one or two values, separated by a white space. The delimiter in the SPLIT is set accordingly and all is put into an ARRAYFORMULA.