Forum Discussion
Klvernon
Jul 15, 2022Copper Contributor
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 ...
- Jul 15, 2022
Detlef_Lewin
Jul 15, 2022Silver Contributor
- KlvernonJul 15, 2022Copper ContributorThat worked like a charm, thank you so much. I should have tried this "community" days ago.