How to split a value after some places in excel row

[Palaniyappan (Palaniyappan P)]

I hope Substring method would work upon the second requirement

@Palaniyappan

str_input = IF(row(“yourcolumnname”).ToString.Contains(“:”),Split(row(“yourcolumnname”).ToString,”:”)(0).ToString.Substring(0,Split(row(“yourcolumnname”).ToString,”:”)(0).ToString.Length-2),row(“yourcolumnname”).ToString)

Cheers @vishnu_prasad21