column b

  1. G

    How to remove two first and two last characters from a column in Excel with one formula?

    Hello. I have my column A in Excel like this: LT013800 LT025200 PL2011000 PL2061000 LV440200 LV604300 EE440000 EE700000 etc. And I want my column B like this(so I want to remove two first and two last characters from column A using one formula): 0138 0252 20110 20610 4402 6043 4400 7000 etc...
  2. S

    Click cell to display multiple options selected

    Hi everyone, Here's the situation or goal that I would like to achieve: Col A = Names Col B = Preferences Selected Each person in Col A has to have 4 Preferences. These preferences are not pre-defined but if I have to put them in a list, I don't think that should be a problem. What I would...
  3. R

    different values in duplicates

    Hi guys, I have 2 columns A and B In first column there are several duplicates. I want to highlight all duplicates that have a different value in column B. So if like this : <TABLE style="WIDTH: 153pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=204...

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