How to do you extract characters from a string in Google Sheets [duplicate]

Question

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.

Welcome. Please add a brief description of you search/research efforts as is suggested in How to Ask. — Rubén, Oct 30, 2019 at 2:04
Possible duplicate Split a column of strings with a single formula returning an array — Rubén, Oct 30, 2019 at 4:23
Once? Just for one cell? Your question misses information, please edit it in. — user55949, Oct 30, 2019 at 11:21

Kos · Accepted Answer · 2019-10-30 02:53:30Z

1

You can split text using menu Google Sheets option Data - Split text to columns:

On next step select Separator: Custom

Result:

answered Oct 30, 2019 at 2:53

Kos

7675 gold badges13 silver badges21 bronze badges

Add a comment |

1 Answer 1