View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc
Wally W. Wally W. is offline
external usenet poster
 
Posts: 11
Default Concatenating formulas

On Sun, 1 Apr 2018 13:18:49 -0700 (PDT), GARYWC wrote:

Cell D5 contains: =INDIRECT("f16") ; the result is: 1:10 PM
Cell E5 contains: ="/ "&INDIRECT("g16")&" degrees" ; the result is: / 78 degrees

When I concatenate both formulas:
=INDIRECT("f16")&"/ "&INDIRECT("g16")&" degrees"
the result is: 0.548611111111111/ 78 degrees

How can I write the concatenated formulas so the result is: 1:10 PM / 78 degrees ?


Please don't multi-post.

You asked this question in microsoft.public.excel.misc.

I am cross-posting from microsoft.public.excel to minimize duplication
of effort -- and possibly to discourage replies to a multi-post.

http://www.theaccessweb.com/netiquette.htm
3. Multiposting is bad!
a. You commit the crime of multi-posting your questions by posting the
same question to several different newsgroups, one at a time.
b. Several folks who could answer your questions take this as a
serious misuse of newsgroups and will likely ignore your questions.