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
HansVogelaar
Jul 15, 2022MVP
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.
- KlvernonJul 15, 2022Copper ContributorI was just provided the solution, thank you.