Extract text

[gauchofife]

Given this phrase in cell A1:

“One, Two, Three,” Four, Five, Six

What formula can I use to extract what comes after the ,” into cell B1. So the result in B1 will be Four, Five, Six

Basically column A has phrases in quotes that always end in comma double-quote space. And I want to pull what comes after that.

 

[DanteAmor]

How about:

Dante Amor
	A	B
1	"One, Two, Three," Four, Five, Six	Four, Five, Six
2	"a, b, c," d, e, f	d, e, f
Hoja3

Cell Formulas
Range	Formula
B1:B2	B1	=MID(A1,SEARCH(","" ",A1)+3,99)

 

[Fluff]

What version of Excel are you using?

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’)

 

[gauchofife]

Thanks you Dante, that works

 

[Peter_SSs]

Thanks you Dante, that works

Good that you have something that works. However, it would still be beneficial if you updated your details as suggested by @Fluff above.
For example, if you have an Excel version with the TEXTAFTER function you could use that single function that is designed for exactly your requirement.

23 05 05.xlsm
	A	B
1	"One, Two, Three," Four, Five, Six	Four, Five, Six
2	"a, b, c," d, e, f	d, e, f
TEXTAFTER

Cell Formulas
Range	Formula
B1:B2	B1	=TEXTAFTER(A1,","" ")

 

[gauchofife]

Thanks Peter, that worked for me as well. And I updated my profile as you suggested. But I use the Mobile app on my phone, 2019 on my work computer and 2013 on my home computer so I’m all over the place.

 

[Peter_SSs]

I updated my profile as you suggested.

Thanks for doing that.

Thanks Peter, that worked for me as well.

Do you mean the TEXTAFTER formula? If so then I still think that there might be something astray with your profile Excel versions as TEXTAFTER is only available in Microsoft 365 and Excel for the web. At least that is what Microsoft details in the TEXTAFTER Help