11a

  1. A

    Searching a cell for unique values

    I'm using the following formula =IF(ISNUMBER(SEARCH("1a.",,$AK2)), "Yes", "No") To search with a cell for 1a. The problem is I get a Yes in cells with 11a. or 111a. What is the tick to find 1a. and 11a. and 111a. distinctly? Thank you!
  2. J

    split data

    i have to require the data in following type automatically main data is 1st row <tbody> 10 11a 12b 15c 18f 11 112 11dfd d1f2d2 </tbody> required as follows <tbody> 10 11a 10 12b 10 15c 10 18f 11 112 11 11dfd 11 d12d2 </tbody> pls suggest

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