View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
toni.gee toni.gee is offline
external usenet poster
 
Posts: 28
Default How do I type text and have a formula in the same cell?

Not quite sure what you are trying to do. If you simply want to display the
formula as text (without the formula being active) then simply preceed it
with an apostrophe. Its not possible to have text and a formula result in the
same cell unless you first convert the formula result into text and then
concatenate it with the main text.

"Mads Beier" wrote:

Is it in any way posible? Either with 'text'=formula or in any wy like that?