Hi. If you can help me please. I have values column but it has simbles on each side of which I need to delete since I only need the numbers. Example: ~40464%
I have used the MID function and it does work. The problem is that the actual format is a date. I can't change the format because it has symbols on each side.
But when delete them with MID, it also cancels the format and doesn't let me to change it to date either. Tried to use the flashfill autofil but not successful.
=MID([@[Order Date]],2,5)
Is there a way to delete the 2 characters on the side of 40464 without deleting the existing date format?
I hope that the query is clear. If it is not apologies
I have used the MID function and it does work. The problem is that the actual format is a date. I can't change the format because it has symbols on each side.
But when delete them with MID, it also cancels the format and doesn't let me to change it to date either. Tried to use the flashfill autofil but not successful.
=MID([@[Order Date]],2,5)
Is there a way to delete the 2 characters on the side of 40464 without deleting the existing date format?
I hope that the query is clear. If it is not apologies