This question already has an answer here:
I'm trying to figure out "how to" split one Google Sheets cell into multiple cells. I'm using the "|" character to identify where the string in one cell should will be split. Ideas?
I have the following in cell B1.
| will always separate values in the single cell.
Chromebook 101 | GHS | 8:00 am | ID#100103
I need to split the data into FOUR parts and into FOUR different cells.
- H1 = Chromebook 101
- I1 = GHS
- J1 = 8:00 am
- K1 = ID#100103
The data is being added to Google Sheets via form input and I need this to update automatically. I assume an
arrayformula will be needed.
If possible, I'd also like to drop the
| from cells H1, I1, J1, and K1.