LeighMacKay7
New Member
- Joined
- Oct 11, 2022
- Messages
- 34
- Office Version
- 365
- 2021
- Platform
- Windows
- Web
Hi all,
Trying to create a work around.
I have two columns of data which I want to concatenate.
One contains qualification name (text) and the other contains a date in dd/mm/yyyyformat.
I would like to concatenate both to view similarly to as follows. Doctoral Degree, 2018.
I have tired the following.
=CONCATENATE(G273&", "&H273) this brings me the result "Doctoral Degree, 'and some random numbers'. I tried to change the format to custom and created yyyy functionality by editing a date function. This still didn't work.
I then tried to create a concatenated function with =RIGHT embed in the formula. But have had no joy.
I then moved on to a different potential solution using =TEXTJOIN(" ",TRUE,G273,", ",H273), but again, I had no joy.
Can somebody please offer a solution.
Trying to create a work around.
I have two columns of data which I want to concatenate.
One contains qualification name (text) and the other contains a date in dd/mm/yyyyformat.
I would like to concatenate both to view similarly to as follows. Doctoral Degree, 2018.
I have tired the following.
=CONCATENATE(G273&", "&H273) this brings me the result "Doctoral Degree, 'and some random numbers'. I tried to change the format to custom and created yyyy functionality by editing a date function. This still didn't work.
I then tried to create a concatenated function with =RIGHT embed in the formula. But have had no joy.
I then moved on to a different potential solution using =TEXTJOIN(" ",TRUE,G273,", ",H273), but again, I had no joy.
Can somebody please offer a solution.