Hi all, I want to split cell values which are separated by delimiter “-” to multiple rows I want the output in the same column and sheet.
like INR - Indian Rupee. I want INR only in that column and delete the data after the delimiter.Tried string manipulation but that doesn’t work, any idea how I can get a solution to it?
Thanks in advance