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.

Concatenating formulas
 

On Mon, 02 Apr 2018 03:58:11 -0400, Wally W. wrote:

On Sun, 1 Apr 2018 15:56:01 -0700 (PDT), GARYWC wrote:

I've deleted my post in microsoft.public.excel.programming and in microsoft.public.excel but I can't delete it in microsoft.public.excel.misc.

Now, how can I get an answer to my post?

Try this if the source cells contain a time and an angle:

=TEXT(f16,"h:m AM/PM")&" / "&g16&" degrees"

I don't know why you are using the "indirect" function. Maybe it needs
to be included at both references for some reason.

Deleting usually doesn't work, so cross-posting to those.

Concatenating formulas
 

When I insert a new row at the top of my spreadsheet, the existing cells move down one row. I then enter the appropriate data in the new row's cells.

The INDIRECT function ensures that the formulas always refer to the cell in the top row of my spreadsheet.