parsing data

Hi I am new to this, i watched a few tutorials and tried out on my own and realize that i can't even do a search in the search box of the webpage. Below is my code that i tried. Sub Automate_IE_Load_Page() 'This will load a webpage in IE Dim i As Long Dim URL As String Dim IE As...

I was hoping someone would be able to assist me with a question regarding parsing data. I have some information that I want to parse to columns. However, the data is inconsistent. Normally, if the data was uniform and consistent, I could have easily used text to columns. Here's a sample of...

Hello! I have a column that has a lot of rows with different text, but the logic of it is always the same. I need to parse this data to columns. Every element should be splitted after "," . And this {} shouldn't be included. So the destination column name are like Key1, Number 1, Meaning 1...

I have a data set with around 10,000 rows in one column that contains approximately 1,500 individual profiles. https://monosnap.com/file/kInwZwsYoJuvhBsY9pQESDxGGZgZ3r I need to transform this data into the following columns Twitter Handle Following Followers Avg. Likes Avg. Retweets...

Good Afternoon, Here is the information that I'm working with. This is a portion of an EDI ERROR email with the trading partner information (it always falls right after the FIRST /) I have highlighted the portion that I want to parse to another column/cell. the position varios depending on the...

I've been creating spreadsheets to cost ingredients in recipes. Copying and pasting text from the Internet worked fine for four days, then yesterday everything I tried to paste into EXCEL seemed to parse on the letter O. Here's an example: <colgroup><col span="3"></colgroup><tbody>...