Read multiple variables on an excel cell

Help
1

Hello everyone, I wish to ask you if you would be so kind to explain me, is there any way to real multiple variables separated by commas inside an Excel cell? (like the one in the image).
image
As you can see, what I need is to extract the different variables mentioned in options, and use them to fill different areas of an online form. As far as I can see, I can read the cvs file, filter and clone the information to save it in a different csv file.
I have been considering data scrapping in order to use those variables in the online form but with little success. What would you suggest?
Thanks in advance for your answers.

2

Hi welcome to the community!
After you read range and use For each row in side the loop you will read like this:
VariableStringArray = row(“Options”).ToString.Split(","c)
And with another For Each using that VariableStringArray, each item will be one option.

3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.