How can we help?

New post
0

Find Specific character and replace

Avatar
Bhawish Raj
None
Follow

Name1 /P, Name2 /N,

Name1 /T, Name2 /P, Name3 /T,

Name1 /P, Name2 /T, Name3 /P,

Name1 /P, Name2 /P, Name3 /T

I have this format of text in my column in klipfolio. Help me out to write a formula to extract only the names which ends up with P. and from the result remove /P.

0 comments

Please sign in to leave a comment.