large amount of text

  1. N

    Finding the largest item within a period using an Array Formula

    <tbody> Item no. Catagory Date Amt A T01 1/1/2017 10 A T01 1/5/2017 15 A T01 5/5/2018 20 B T01 1/1/2017 15 B T01 1/1/2017 15 B T02 1/1/2017 15 ..... </tbody> I'm trying to determine the item no. under catagory "T01", within a period from 1/1/2017 to 1/31/2017...
    • nyx1234
    • Thread
    • array formula item large amount of text multiple critera lookup sum array
    • Replies: 5
    • Forum: Excel Questions
  2. J

    Split large text in a cell upto a specified number of characters (conditions apply)

    Hello, Can somebody please help me in finding out the answer of the below problem : I have a large text in one cell (2000 to 5000 characters). There are small sentences in this text each separated by a comma (,). I want to split this text in 1000 characters in each separate cell. I can do...
    • jhamnani
    • Thread
    • large amount of text left mid mid find len split cell
    • Replies: 2
    • Forum: Excel Questions
  3. J

    Split large text in a cell upto a specified number of characters (conditions apply)

    Hello, Can somebody please help me in finding out the answer of the below problem : I have a large text in one cell (2000 to 5000 characters). There are small sentences in this text each separated by a comma (,). I want to split this text in 1000 characters in each separate cell (Example in...
  4. J

    Text boxes / frames of equal size and variable content

    I want to add a set of rectangular text boxes / frames all the same size, but with different amounts of text. I'd like to have the box / frame accommodate the additional text by converting it to a scrolling canvas, scrolling within the text box / frame. I do not want the remedy for too much...

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