Afro_Cookie
Board Regular
- Joined
- Mar 17, 2020
- Messages
- 103
- Office Version
- 365
- Platform
- Windows
I want to concatenate 2 columns so that text appears after a date and the date formatting does not change. When I do, the new column converts that date to text and generates a new text "44224-text".
Is there a way to display the "date-text" while maintaining the date formatting?
example:
Column A : 5/19/21
Column B: "-test"
Current Column C outcome: 44335-test
Desired Column C outcome: 5/19/21-test
Is there a way to display the "date-text" while maintaining the date formatting?
example:
Column A : 5/19/21
Column B: "-test"
Current Column C outcome: 44335-test
Desired Column C outcome: 5/19/21-test
