split()

  1. M

    INSTR() not returning the correct number of occurrences.

    I'm attempting to import comma delimited data into an array but need to replace the 187th element of each line if the total number of commas in the string is equal to 192. The problem being that I can't determine the number of commas in the string. Sample .txt file ...
  2. D

    VBA code to set 2 column Combobox values

    I'm abbreviating my descriptions to paint the picture. I have a userform that has 2 comboboxes on it. cmbPartNumber and cmbAccount cmbAccount is 2 columns populated from a worksheet For each row there is always a value in column 0 and sometimes a value in column 1 Click save on the userform...

We've detected that you are using an adblocker.

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.
Go back
Back
Top