Extract

[How_Do_I]

If A1 contained the following text "Cabinet Conclusion: Minutes and Papers: CAB 65/3/35" how would I extract the "CAB 65/3/35" please?

 

[jtakw]

Hi,

One sample is usually not enough to go on, so if your data is Always in that format but with varying lengths, use B1 formula.
If it's Always the last 11 characters, then as simple as B2 formula.

Book1
	A	B
1	Cabinet Conclusion: Minutes and Papers: CAB 65/3/35	CAB 65/3/35
2		CAB 65/3/35
Sheet76

Cell Formulas
Range	Formula
B1	=TRIM(RIGHT(SUBSTITUTE(A1,":",REPT(" ",100)),100))
B2	=RIGHT(A1,11)

 

[How_Do_I]

Thanks for that, my data is in that format...

 

[jtakw]

You're welcome.