text entry

  1. N

    dependant lists and manual text entry problem

    Hi all, I am relatively new to Excel. I have figured out how to use named ranges as lists and use INDIRECT Data Validation to have a list's selection made in one cell populate a new list in an adjacent cell. However, I have a situation I cannot figure out to save my life. A1 contains a list...
  2. L

    how to count number of text entries in a range?

    I have a spreadsheet with a named range ("Names") that contains a list of business names. I want to find out how many businesses have names starting with the letters specified in an interval. For example, I want to answer a question like: How many businesses have names that start with letters...
  3. L

    autofil contiguous cells

    Dear Smart people: i'm using excel 2007, and i've seen Bill select a rectangular group of cells with his mouse, then type a word in the upper-most top left cell (which is white), then all the other cells automatically populate with that same word. i can't get this and searching 'autofil' in...
  4. LearningOnTheFly

    How do I Assign a Numeric Value to Combo Box Selections that are a Text DataType??

    Hello everyone! Help! I have created combo boxes in several tables in which I need to assign a numerical value to each option chosen so I can calculate a numerical “score” based upon what each user has selected. For example: Not Applicable = 0 Introduced = 1 Emphasized = 2 And so...
  5. T

    format a merged cell to act as a word document

    I've created a change order workbook which requires an input of text into each change order sheet. In order to make it easier and more user friendly, I'd love to be able to format a merged section of cells into a text editor much like this comment box so that I can use tab functions, return key...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top