How can i make bold part of a text in a cell?

[iRasim]

For example; in A1 typed "Rasim Quliyev". I want to make Rasim bold, remain Quliyev as before.if it is possible I want to do it from A1 to A100?

 

[vletm]

write text, activate like below, press [ B ], press <Enter>, make copies

 

[iRasim]

I can do it. I want to know if it is possible do it with formula in array not only for a cell. I wrote above. I want make bold first part of a text in A1:A100 array.

 

[Chihiro]

You can't.
But there's workaround using text box or done via VBA.

Textbox
http://www.mrexcel.com/forum/excel-questions/75061-formatting-text-bold-within-formula.html

VBA
http://stackoverflow.com/questions/10295380/excel-vba-make-part-of-string-bold