Apr 19, 2021
2:53:17pm
2:53:17pm
Excel question:
Right now I have a date in the following format: '01.01.2021
How do I get the text indicatory (the apostrophe) removed?
Or better yet, how do I get the full date to be in the following format: 1/1/2021
I have tried to use text to columns, changing the format, and using the "right" function to try and get rid of it, and search and replace but the apostrophe is not searchable.
How do I get the text indicatory (the apostrophe) removed?
Or better yet, how do I get the full date to be in the following format: 1/1/2021
I have tried to use text to columns, changing the format, and using the "right" function to try and get rid of it, and search and replace but the apostrophe is not searchable.
- Bio page
- ChiCityCoug
- Joined
- Sep 11, 2016
- Last login
- Apr 29, 2024
- Total posts
- 9,702 (20 FO)
