vladimiratanasiu
Active Member
- Joined
- Dec 17, 2010
- Messages
- 346
- Office Version
- 2021
- 2019
- Platform
- Windows
Hello!
I have a table including days of the week and their annual equivalent date, that can be accessed by the link pontaj.xlsx . I need to combine automatically in the same cell the name of each day with its real annual date, but keeping only the first one / two letter(s) of that day and its equivalent date from the month, as is shown in the column E from the table. My question is whether I could apply a special format, a formula etc., in order to get the necessary structure of the content. Thank you!
I have a table including days of the week and their annual equivalent date, that can be accessed by the link pontaj.xlsx . I need to combine automatically in the same cell the name of each day with its real annual date, but keeping only the first one / two letter(s) of that day and its equivalent date from the month, as is shown in the column E from the table. My question is whether I could apply a special format, a formula etc., in order to get the necessary structure of the content. Thank you!