Separate excel format by columns

how can i reach this part of excel to separate by columns??
or can i use any VB code or any activity?

Sin título

thank you!!

Regex can be useful in this case. What is the type of raw input file? Is it a CSV file?

Hi @amy93amanda !
If I understand well:

  • in a specific cell (for instance A3) you have all these information
  • you would like to separate all these data into several columns
  • these data can be always split with this number of characters

Is it ?
If so, would you mind sending us a sample of the data ? (At least 2 lines)