View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey Duke Carey is offline
external usenet poster
 
Posts: 1,081
Default Formating text in a calculation

Sorry, but Excel does not allow you to separately format subsets of a
formula's result

"Tim" wrote:

I have a formula that looks like this:

=CONCATENATE("Placement of ",B7, " inch, ",ROUND(B9,2),"% lime stabilized
subgrade")

I need the cell references to stand out, so I want to format only the two
numbers to underline, boldface, and a larger font size. Is there a way to do
this?

Thanks in advance