This question already has an answer here:

I have a string in a cell: A|BCD|EF|GHI|JK.

I would like to extract it separate in individual cells: A should be in one cell, BCD in the next, EF in the next, and so on.

I would appreciate any help on this. Thank you.

marked as duplicate by Rubén, serenesat, Community Oct 30 at 15:37

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.


You can split text using menu Google Sheets option Data - Split text to columns: enter image description here

On next step select Separator: Custom

enter image description here


enter image description here

Not the answer you're looking for? Browse other questions tagged or ask your own question.