how can i reach this part of excel to separate by columns??
or can i use any VB code or any activity?
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)