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.

Channel Tips - July 5th – Redefining Channel Management Through A Unified Lens
Newsletter Blast		Sent	Delivered	Delivery %	Email Open	Email Open %	click through	click through%	Unsubscribed	Unsubscribe %	Bounced	Bounce %
NORAM – w/o B&C	July 5th - Redefining Channel Management Through A Unified Lens - NORAM – w/o B&C	5340	5278	98.84%	259	4.91%	7	2.70%	13	0.25%	62	1.16%
APJ – w/o B&C	July 5th - Redefining Channel Management Through A Unified Lens - APJ – w/o B&C			#DIV/0!		#DIV/0!		#DIV/0!		#DIV/0!		#DIV/0!
EMEA – w/o B&C	July 5th - Redefining Channel Management Through A Unified Lens - EMEA – w/o B&C	527	514	97.53%	33	6.42%	1	3.03%	1	0.19%	13	2.47%
Grand Total		5867	5792	98.72%	292	5.04%	8	2.74%	14	0.24%	75	1.28%

<tbody>
</tbody>

 

[AliGW]

Like this in B3, dragged down:

Excel 2016 (Windows) 32 bit

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

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet2​

Worksheet Formulas Cell Formula B3 =RIGHT($A$1,LEN($A$1)-FIND("-",$A$1)-1)&" - "&A3 <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[RoryA]

Cross-posted here: Make Sentence By formula

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