I tried the Alt Enter method, but it does not work with a formula.
Example of desired output:
“The new title is:
“The new title is:”
Variable input field in cell B3: (Value will vary in character length and word count)
Current formula (Please see the attached workbook)
="The new title is:"&B3