Last answered:

20 Mar 2023

Posted on:

17 Mar 2023

0

Resolved: Using Text to Columns

Is it easier and safer, since we know as you said, that period has  digits in all cses to use Text to Columns option with fixed weidth? We would end up in  rows as well, split for Month and Year.

1 answers ( 1 marked as helpful)
Instructor
Posted on:

20 Mar 2023

0

Hi Dijana,

Any approach that would split the data correctly is more than welcome! Feel free to try and experiment with different approaches. If you're able to split the data properly, then that's perfect.

Best,

Ned

Submit an answer