Concatenate with line break & ==

[allen675]

Hello fellow Excel people,

I want to concatenate several different cells with a line break and ==

For example:

Text
==
Text
==
Text
==

Some of the cells already contain formulas but I want the text value and not the formula to be copied. I want to be able to then copy and paste the final concatenated cell into a word document carrying across the line breaks and "==" line separators. I don't mind if this is accomplished by either a formula or VBA code.

I look forward to your suggestions

 

[Fluff]

How about

=SUBSTITUTE(TEXTJOIN("|==|",,B4:D5),"|",CHAR(10))

 

[allen675]

@Fluff works a treat, thank you

 

[Fluff]

You're welcome & thanks for the feedback.