Formula Help Please II

[How_Do_I]

Where am I going wrong here please... In my workbook there is a lot more text after the word "Attendees:" in cell B3... What I need to extract is "CC 1 (25)"...

Excel Workbook
	B	C
3	Record Type: Conclusion. Former Reference: CC 1 (25). Attendees:	CC 1 (25). Attendees:
Sheet1

 

[silentwolf]

Hi,
you could use this custom function.

Function Attendees(strText As String) As String
    Dim intPos As Integer
    
    intPos = InStr(strText, "CC 1")
    Attendees = Mid(strText, intPos)

End Function

 

[Gerald Higgins]

Do you mean you want to show
CC 1 (25)

and not
CC 1 (25).Attendees:

?

With this type of thing, it's usually best to provide several slightly different examples of what you want to do, so we can establish some kind of general rule for your data.

 

[jtakw]

Hi,

As pointed out above, it's best to show a few samples of Possible variations of your Text strings.

Based solely on your Single sample:

Book1
	B	C
3	Record Type: Conclusion. Former Reference: CC 1 (25). Attendees: John Doe, Jack Doe, Jane Doe, etc.	CC 1 (25)
Sheet602

Cell Formulas
Range	Formula
C3	=TRIM(LEFT(SUBSTITUTE(MID(B3,SEARCH("Reference:",B3)+10,99),".",REPT(" ",99)),99))