Identifying keywords and placing in other column

Hi ,

I want to identify string as in first column and place the value the in column b
as below
image

As in column A identifying a string and place the same in column B.

Hello @Karthik_Kulkarni,

you can exploit split() method to get first name,

Thanks,
Pankaj

1 Like