Extracting keyword from text

[PrashanthKumar123]

I am working on an excel project that involves analyzes keywords from text strings. Below is one text input and I'm trying to figure the easiest way to output all characters post the first character "," from the right. In this case, the output expected is "UPI"


IMPS OUTWARD ORG UPI To paytmqrXXXXXXXXX1015tmy4w7ksb2r@paytm,REF NO - 024620963921, UPI

 

[Fluff]

Hi & welcome to MrExcel.

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

+Fluff 1.xlsm
	A	B
6
7	IMPS OUTWARD ORG UPI To paytmqrXXXXXXXXX1015tmy4w7ksb2r@paytm,REF NO - 024620963921, UPI	UPI
Main

Cell Formulas
Range	Formula
B7	B7	=TRIM(RIGHT(SUBSTITUTE(A7,",",REPT(" ",100)),100))

 

[PrashanthKumar123]

Thank you for the prompt response! This one works!

Updating my Account Details as well!

 

[Fluff]

You're welcome & thanks for the feedback.