different font format in the same cell but using a formula

K

karlo

Hi there to anyone who is willing to help:)

Is it possible to use CONCATENATE(A1," ",B1)
where A1 ="hello" and B1="there" but the font format is different

the usual result is: hello there

but my desired result is: *hello* there

thanks to anyone who knows the answe
 
Top