Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Concatenating Formulas | Excel Programming | |||
Need help concatenating and formulas | Excel Discussion (Misc queries) | |||
Concatenating two formulas | Excel Discussion (Misc queries) |