text length

  1. dss28

    code to limit text length to variable characters in the same textbox - option button use

    I want a user to select option button which will control the text length in a text box. Some users may fill e.g. text upto 200 characters, some to 400 characters etc. to describe an event in the same text box in a userform I have designed. I do not have any code but can anybody suggest...
  2. jmacleary

    Showing cell text length while typing

    Hello folks. I want to be able to see how many characters I am typing into a cell as I type. I know there are many ways to see the length after the data is entered, but I need to see the count 'in-flight' if possible.
  3. M

    Custom format - show only the 6 first characters

    Hello, Small problem. I have wide table for punching data. For many columns there is the same two word as headers. (the dates might change so can't use formula in the tableheaders). Creating the table will then leave me with: Budget | Actual | Budget1 | Actual1 | Budget2 | and so on. So I...
  4. andrewb90

    data validation help

    Hi all, I am trying to put data validation on some cells that will not allow any entry if H6 has a text length of less than 4. Can anybody help with this formula? Thanks Andrew
  5. H

    Limiting character length of excel cells/columns

    Hello. I am trying to limit the number of characters in an Excel 2010 worksheet created with data imported from another program. Specifically, I need each column to have no more than 30 characters. I have tried the Data Validation technique, but this does not seem to work with imported data...
  6. A

    cell contents - 10 digits or greater

    I am trying to force my users into giving me data in a certain format. this particular cell needs to be atleast 10 numbers long, or if its greater than 10, the eleventh must be "/" followed by a last single numeric. for example: 1234567891 or 1234567899/1

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