Pull data after specific text

[Al99]

Hi All,

I would like some help on trying to figure out how to perform the following:

In cell A1 I have the following format of data:
"Performance: Improvement
Performed by: Joe Bloggs"

Essentially, I would like to pull the text just after 'Performance:' part and also pull the text just after 'Performed By:'

This will help me understand if the text is left blank just after 'Performance:' & 'Performed By:'
There is no specific amount of characters that will be after the 'Performance:' & 'Performed By:', this will vary.

Any ideas on how this can be done?

Thanks in advance

 

[Peter_SSs]

maybe this single formula also works
(if only I had let to avoid the repeated filterxlm part...)

Or perhaps just this? (Though I don't see any inherent advantage in using a single formula over two even simpler ones)

20 12 13.xlsm
	A	B	C
1		Performance	Performed By
2	Performance: Improvement Performed by: Joe Bloggs	Improvement	Joe Bloggs
3	Performance: Performed by: Joe Bloggs		Joe Bloggs
4	Performance: Improvement Performed by:	Improvement
5	Performance: Performed by:
6	Performance:Increasing Improvement Performed by:JB	Increasing Improvement	JB
Extract Text (2)

Cell Formulas
Range	Formula
B2:C6	B2	=TRIM(MID(SUBSTITUTE($A2,CHAR(10)&"Performed by:",REPT(" ",99)),COLUMNS($B:B)*99-86,99))

 

[GraH]

Or perhaps just this? (Though I don't see any inherent advantage in using a single formula over two even simpler ones)

True, I hardly use formulae any more for these kind of "challenges" and jump to Power Query.

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    SplitText = Table.AddColumn(Source, "Split", each List.Transform(Text.Split([Column1],"#(lf)"), each Text.Trim(Text.AfterDelimiter(_, ":")))),
    #"Extracted Values" = Table.TransformColumns(SplitText, {"Split", each Text.Combine(List.Transform(_, Text.From), ";"), type text}),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Extracted Values", "Split", Splitter.SplitTextByEachDelimiter({";"}, QuoteStyle.Csv, false), {"Split.1", "Split.2"})
in
    #"Split Column by Delimiter"