Hi all, I want to split excel cell values which are separated by delimiter “|” to multiple rows within the same excel. Tried string manipulation but that doesn’t work, any idea how I can get a solution to it? Thanks in advance

Split excel cell values separated by delimiter to multiple rows

sarathi125 (Parthasarathi) November 25, 2019, 11:42am 4

So are you expecting the output like the following,

How to split excel cell multiple values and write in single cell