Populate Rows & Columns by Comma Split version 1
Good day mate, got the problem above solved!
but it would be a bit of a problem to implement since my sheet column is dynamic starting from 96 columns and 6000 rows on a quarterly period
would anyone kindly help this poor guy to implement a...
In Excel, I need to pull part numbers from the URLs in a site map. The URLs look something like this:
http://www.mysite.com/shop/catalog/category1/category2/category3/category4/item/partnumber1/part-title1...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.