I have a cell with the following equation:

=CONCATENATE("Goal = ", Sheet2!B4)

I want the first four characters, the word Goal, and only the first four characters, to appear in bold.

Is this possible, VBA or otherwise?

Thanks!