Sir How to derive name from the following string.

[ThrottleWorks]

Sir I have Names as


Product : Sachin Sonawane,

Product : Sachin 123,

Product : Sachin 145.


My problem is I want to populate names only i.e. Sachin Sonawane.


Everything after the character : should be present in next cell.


I tried =right & = Len, but I am not able to find position of : in the string.

Can anyone help me in this please.

 

[ThrottleWorks]

Sir I did it in the following way....


=RIGHT(A1,((LEN(A1))-(FIND("-",A1))))


Sorry for the trouble.

 

[vicmoment]

This should work I guess


=RIGHT(A1,LEN(A1)-FIND(":",A1)-1)


@sachin: You used find("-"), I should think that would be find(":")

 

[Luke M]

You could have also done Text to Columns with the colon as delimiter.

 

[vicmoment]

I totally agree with Luke M