Split remove and trim

Hi want to remove Mr. and space like this name
pls help me
Mr. Anandhan Ramamoorthy

Can you be more clear with what you have and what you want it to be ?

Hi,
thanks for quick reply
i have data like this
Mr. AKASH KUMAR
Pankaj kumar Vasudev vishwkarma
Mr. HARICHARAN
Mr. PRADEEP KUMAR
RAVINDRA

but i dont want want mr, dot and space after mr. only i need name
like this
AKASH KUMAR
Pankaj kumar Vasudev vishwkarma
HARICHARAN
PRADEEP KUMAR
RAVINDRA

For each name
If Name.ToLower.Startswith(“mr.”)
{
Name.Substring(3,Name.length-3).Trim.Replace(".","")
}

Thanks @GSR
i am trying

Thanks a lot its working fine
@GSR

Cool. Please mark it as complete if it solved your case. This will not confuse others.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.