Suppose, in Excel, I have cell value equal to
"2020 Aug ABC"
I want to convert this to 202008
date format using an excel formula because I would want to use the output value, that is, 202008 to perform some operation.
Suppose, in Excel, I have cell value equal to
"2020 Aug ABC"
I want to convert this to 202008
date format using an excel formula because I would want to use the output value, that is, 202008 to perform some operation.
If your data is in
A1
: