Right String formula

[Jagdev Singh]

Hi Experts

Could you please help me with the formula which will pull string of words from the right side of the sentence.

Regards,

JD

 

[Khalid NGO]

Hello JD and Good Day...
Try this:

=MID(A2,FIND("'",A2)+1,999)

Find is looking for the red highlighted string.

Regards,

 

[Jagdev Singh]

Thanks Khalid! you are a champ!

 

[Jagdev Singh]

Hi Khalid

Please let me know if it is possible - I want to remove \par, 22, } from the output. I mean can we create single formula which will replace this as well.

Regards,
JD

 

[Khalid NGO]

Hi Khalid

Please let me know if it is possible - I want to remove \par, 22, } from the output. I mean can we create single formula which will replace this as well.

Regards,
JD

JD sorry, I am not getting your point...
can you provide your desired result?

Regards,

 

[Jagdev Singh]

Hi Khalid

Please find the revised sample file attached with the mail.

Regards,
JD

 

[Khalid NGO]

JD I am sure there would be more ways, here is i came up with:

=TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(MID(A2,FIND("'",A2)+3,999),"\'22",""),"par",""),"\",""),"}",""),"-",""))

Regards,

 

[Jagdev Singh]

Thanks Again Champ!

Regards,
JD