View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default HOW TO FORMATE PART OF TEXT FROM TEXT STRING

Not as long as it is part of a formula.


--


Regards,


Peo Sjoblom


"Vishal" wrote in message
...
Hi,
Thanks a lot in advance for your help which will help me a lot.

I wanna to bold the part of text from the text string which is in one
cell,this is the string which is joined from different cells into one cell
by
using function "CONCATENATE".

Here is the formula to be used
=CONCATENATE("I have ",C42," Rs with me.")
result ;
I have 500 Rs with me.

I wanna to do "500" bold, is there any way for this.

Waiting for the reply,
Regards,