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.