substition

  1. N

    How can I search a similar item - so stuck on this!

    So I have a rather large excel spreadsheet with a list of items and their codes, eg: 3652 Milk 1ltr 6743 Milk 2ltr 9287 Milk 3ltr 7264 Cheese 200g 7635 SC Cheese 120g I am trying to create something whereby I type one of the numbers into a cell (say F2) and in the cell next to it...
  2. N

    Using substitution with a changing value

    Hi, In cell a1 I have the following text "45 students fail test 5 of report" ok so I want to remove test 5 from the cell so I used =subsitiution(a1,"test 5","") and this worked but my cell a1 the number of test keep changing from test 1 to test 2 all the way up top test 9, so all I want to do...

This Week's Hot Topics

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
Top