NEed bold data only

[sksanjeev786]

HI Team

I need data for data between of Flex statement1 and 2 example in row 3 for rest of data

The ad gave the impression the vehicle is fun to drive.
The ad gave the impression that the brand has technology that links all entertainment together

Data.xlsx
	A
3	FLEX STATEMENT 1: The ad gave the impression the vehicle is fun to drive. FLEX STATEMENT 2: The ad gave the impression that the brand has technology that links all entertainment together
4	FLEX STATEMENT 1: The ad gave the impression that this brand is sophisticated. FLEX STATEMENT 2: The ad gave the impression that the brand does not stop innovating itself
5	FLEX STATEMENT 1: The ad communicates that the vehicle is all new . FLEX STATEMENT 2: The ad gave the impression that the brand has all-new exterior and interior design
6	FLEX STATEMENT 1: The ad communicates that the vehicle is all new . FLEX STATEMENT 2: This brand has award winning vehicles
7	FLEX STATEMENT 1: This ad fits my lifestyle. FLEX STATEMENT 2: The ad gave the impression the vehicle is fun to drive
8	FLEX STATEMENT 1: The ad gave the impression that this is a newly redesigned vehicle. FLEX STATEMENT 2: The ad gave the impression the vehicle offers high performance
9	FLEX STATEMENT 1: The ad communicates that the vehicle is all new . FLEX STATEMENT 2: The ad gave the impression the vehicle helps me to achieve my dreams
10	FLEX STATEMENT 1: The brand in this ad stands for things that are important to me. FLEX STATEMENT 2: The ad made me feel that the brand fits my personality
Sheet5

 

[GraH]

Maybe trim(mid(A3, 18, search("2:", A3)-15))

 

[sksanjeev786]

Maybe trim(mid(A3, 18, search("2:", A3)-15))

Hey Grah,

Thanks for checking on this

i need 2 statement in 1 cell both after flex statement

Based on below

The ad gave the impression the vehicle is fun to drive.
The ad gave the impression that the brand has technology that links all entertainment together

Thanks.

 

[GraH]

Maybe, amend the formula with & mid(A3, search("2:",A3)+2, 1000)

 

[sksanjeev786]

Maybe, amend the formula with & mid(A3, search("2:",A3)+2, 1000)

Hey Grah it work quite well but it is not applicable for both scenario.

But thanks for you hlep on this