Hello everybody,
First of all I am very happy that I found place like this forum. Thank you for all of your contribution.
Long story short - I need to copy this kind of information multiple times (screenshot below):
45ddf8a9466251a32f4aa3796a154c3a.png
Information from screenshot is different but it has only options from 1 to 20. What I mean that it has 20 different texts which can be shown as possible.
So, once i copy it to the excel it comes out like this (screenshot below):
429c15e7decbcc4b569b50a918e03f8f.png
And I need it to look like this (screenshot below):
70a88ecaf947015ddba131e967f1a148.png
I need that excel would recognize specific text, for example word strong has to be recognized as number 8. And most important once it is pasted into excel i need all the lines to go to the different columns. What i mean, that Inside shouting would go under IS column and the rating would appear under that specific column.
Is it hard to make it work like this? I know that people once already made this thing but I have lost contact with these people.
Even if nobody will help me - Thank you for your time reading. I hope everything will be good in your life.
Bookmarks