View Single Post
  #2   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.misc
Wally W. Wally W. is offline
external usenet poster
 
Posts: 11
Default 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.