0

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.

1

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

Result:

enter image description here

| improve this answer | |

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