Not possible with a formula.

--

Vasant

"karlo " wrote in message
...
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 answer


---
Message posted from http://www.ExcelForum.com/