Hi All,
I recorded the following macro:
Upon running the recorded macro on a copy of the raw data, I get a different output.
The result of the action was as follows:
I recorded the following macro:
VBA Code:
Sub TtoC()
'
' TtoC Macro
'
'
Columns("Q:Q").Select
Application.CutCopyMode = False
Selection.TextToColumns Destination:=Range("Q1"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
:=Array(1, 4), TrailingMinusNumbers:=False
End Sub
Upon running the recorded macro on a copy of the raw data, I get a different output.
The result of the action was as follows:
Accounting Period - Raw data | Accounting Period - After Manual Text to Columns |
| |||
Feb-22 | 1/02/2022 | 22/02/2022 |