Forum Discussion

Klvernon's avatar
Klvernon
Copper Contributor
Jul 15, 2022
Solved

Concatenate & #value! error

I am using the following function =CONCATENATE(TEXT(I83,"m/d/yy h:mm")," ",TEXT(J83,"text")) to combine the contents of two cells. The problem is that the second cell J83 is formatted as General and ...
  • Detlef_Lewin's avatar
    Jul 15, 2022

    Klvernon 

    Why not?

    =CONCATENATE(TEXT(I83,"m/d/yy h:mm")," ",J83)

Resources