representation

  1. B

    Remove the first word of every sentence in a cell

    Hello, For the sentence: "A map is a visual representation . The work of a map is to illustrate geography." I know that the formula "=RIGHT(B2,LEN(B2)-FIND(" ",B2))" will remove the first letter in the string. Leaving "map is a visual representation . The work of a map is to illustrate...
  2. J

    Conditional Printing

    Good Morning! I have a bit of a question. Right now, I'm trying to make an inventory of the supply room which I will keep updated. I'm just wondering if there's a way that excel can ignore if, for example, G7 is empty so therefore it will not print the whole row. This is a very crude...
  3. R

    Excel and non table structures - trees, nested sets and modified pre-order tree traversal

    Is tree representation possible in excel? Any material to read, examples?
  4. N

    Create a visual representation of data pulled via formula (vlookup? indexmatch?)

    Iam trying to show visual representation of which agencies had what percentageof candidates on an interview slate for each department. From the examplebelow, firm 2 had two candidates on slate for the FN openings, firm 1 had 1 andfirm 3 had one. So, not only do I need a way to pull this data...

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