Make Sentence By formula

[Sanjib85]

Hi

i want to make this sentence (Red Color) by formula. Please any one help me how do i make it. [TABLE="width: 1581"]
<tbody>[TR]
[TD="colspan: 13"]
Channel Tips - July 5th – Redefining Channel Management Through A Unified Lens[/TD]
[/TR]
[TR]
[TD]Newsletter Blast[/TD]
[TD][/TD]
[TD]Sent[/TD]
[TD]Delivered[/TD]
[TD]Delivery %[/TD]
[TD]Email Open[/TD]
[TD]Email Open %[/TD]
[TD]click through[/TD]
[TD]click through%[/TD]
[TD]Unsubscribed[/TD]
[TD]Unsubscribe %[/TD]
[TD]Bounced[/TD]
[TD]Bounce %[/TD]
[/TR]
[TR]
[TD]NORAM – w/o B&C[/TD]
[TD]July 5th - Redefining Channel Management Through A Unified Lens - NORAM – w/o B&C[/TD]
[TD]5340[/TD]
[TD]5278[/TD]
[TD]98.84%[/TD]
[TD]259[/TD]
[TD]4.91%[/TD]
[TD]7[/TD]
[TD]2.70%[/TD]
[TD]13[/TD]
[TD]0.25%[/TD]
[TD]62[/TD]
[TD]1.16%[/TD]
[/TR]
[TR]
[TD]APJ – w/o B&C[/TD]
[TD]July 5th - Redefining Channel Management Through A Unified Lens - APJ – w/o B&C[/TD]
[TD][/TD]
[TD][/TD]
[TD]#DIV/0![/TD]
[TD][/TD]
[TD]#DIV/0![/TD]
[TD][/TD]
[TD]#DIV/0![/TD]
[TD][/TD]
[TD]#DIV/0![/TD]
[TD][/TD]
[TD]#DIV/0![/TD]
[/TR]
[TR]
[TD]EMEA – w/o B&C[/TD]
[TD]July 5th - Redefining Channel Management Through A Unified Lens - EMEA – w/o B&C[/TD]
[TD]527[/TD]
[TD]514[/TD]
[TD]97.53%[/TD]
[TD]33[/TD]
[TD]6.42%[/TD]
[TD]1[/TD]
[TD]3.03%[/TD]
[TD]1[/TD]
[TD]0.19%[/TD]
[TD]13[/TD]
[TD]2.47%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD][/TD]
[TD]5867[/TD]
[TD]5792[/TD]
[TD]98.72%[/TD]
[TD]292[/TD]
[TD]5.04%[/TD]
[TD]8[/TD]
[TD]2.74%[/TD]
[TD]14[/TD]
[TD]0.24%[/TD]
[TD]75[/TD]
[TD]1.28%[/TD]
[/TR]
</tbody>[/TABLE]

 

[AliGW]

Like this in B3, dragged down:

Excel 2016 (Windows) 32 bit

	A	B
1. Channel Tips - July 5th – Redefining Channel Management Through A Unified Lens
Newsletter Blast
NORAM – w/o B&C	July 5th – Redefining Channel Management Through A Unified Lens - NORAM – w/o B&C
APJ – w/o B&C	July 5th – Redefining Channel Management Through A Unified Lens - APJ – w/o B&C
EMEA – w/o B&C	July 5th – Redefining Channel Management Through A Unified Lens - EMEA – w/o B&C

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]

[TD="align: center"]2[/TD]

[TD="align: right"][/TD]

[TD="align: center"]3[/TD]

[TD="align: center"]4[/TD]

[TD="align: center"]5[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet2​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B3[/TH]
[TD="align: left"]=RIGHT($A$1,LEN($A$1)-FIND("-",$A$1)-1)&" - "&A3[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[RoryA]

Cross-posted here: Make Sentence By formula

Please read the forum rules on cross-posting and follow them in future. Thank you.