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.
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityI 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.