words

i want to be able to stop a user adding more then 100 words into a cell. i have a cell B16 in which the user puts in a description and i want to limit it to 100 words

Hi, Is there a way to modify the way Excel sorts cells? This "A to Z" or "Z to A" algorithm is faulty as hell and apparently hasn't been updated since the dawn of time. It constantly sorts words in many languages in a horribly wrong order. Is it possible to create custom sorting routines...

How can I convert my excel spreadsheet from these strange characters into words and numbers?

I am attempting to hyperlink multiple words in a comment section on Excel 2016. When right clicking on a work in the comment, the hyperlink is grayed out and dos not allow for a hyperlink. The only option is to hyperlink the entire cell. Is there a setting that needs to be changed in order to...

Good Morning, I have this formula to give me the percentage completed by count of project =COUNTA(L5:L10)/COUNTA(B5:B10) but what i need is that if in L5:10 have the words "Completed to give me the percentage only when the words completed are in the cell and not to count any other words in the cell

Hi, I would like to ask a macro where it will search through a folder and subfolder and put the result in columns in excel. Sample is : words to look in a note file - 'Note', 'black", 'white', 'blue' if 2 words found: column1 column 2 C:\document\txt1...

Hi, I currently have a macro to search words in folder and put the result in my excel. However, it only gives me one result where i want to give me all words found in the text files available in the folder. Sample: If i have 2 words found on the text1.txt it will give me the result 2 rows...

Hello, I would like some sort of data validation, or vba code to stop people entering the wrong information. I have a list of words which gets coloured in conditional formatting. Sometimes people put in the wrong words. For instance i have the word "Holiday" in conditional formatting turn red...

Hello and thanks in advance for any assistance. I have a work sheet with two tabs named DATA PULL and LIST. The LIST tab contains a list of keywords (250 words) in column A. I need to search for those key words in columns P and Q on the DATA PULL tab and return any matches to column I(the data...

<code style="box-sizing: inherit; margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera...

Situation is, I am using the following code to get some pretty specific text over from column A to column C. =TRIM(SUBSTITUTE(A57,B57,"")) The first 2 words are always equal to Network Bridge, followed by other text. My question is, is there a way to eliminate the space between the words...

I have raw text data in cell A1 I also have list of words that I want to be bolded to that cell. (These words are listed in column B) I want it to be like this: Bold every "Jack" and "John" in cell A1: Jack and John are brothers. Jack is older than John. Jack likes football but John hates...

This is probably pretty easy, but I can't figure it out. Obviously I can SUM a column. However, I want to SUM the next column (Column D), but I'm trying to SUM column C but ignore any entries that have certain words from Column A (Mom, Dad, and Lisa). How do I put that in a formula for cell...

I am looking at getting some help. I have a spreadsheet, with items in it. I need to write a formula in the conditional formatting, new rule section. How do you instruct excel to automatically recognise specific words out of a linked list once any of them have been entered more than once...

Hi, again peeps. I am trying to remove irrelevant data from a table, I am trying to include a .find string but cannot seem to locate it on VBA... and then loop into the next word from a chosen set of words List of specific words to find: Hello, Goodbye and Select(makes things difficult...) I...

In the attached sample file, I need to separate Column B (Asset Description)into 3 columns. The maximum number of characters per column is 43 characters. However, it is important that no words are split down the middle. If the original data is less than 43 characters to begin with, it can...

Dear Sir or Madam: My name is Robert, and I have just one more Excel formula issue before I fall asleep. The following formula works perfectly, but I want to add exceptions to it. I need Excel to find a cell that contains "minimum", "maximum", and range" with any other words except the...

Hello, I have one range I am trying to count the occurrence of aword, based on two other rows criteria. Probably better explain with an example. A1:A5 contains the word “Closed” or “Open” I want to counthow many time the word “Open” is present, based off of the two following rowsbeing true...

Hi Friends, I tried with a formula creating Boolean strings but its time consuming every time. This is an example: In Column, AI have list of words from A1:A50, It varies every time from A1:A50. ColumnB AND words ColumnC NOT words Here I want to build Boolean strings in ColumnD. In ColumnD...

I have a form on which I have first name, Middle name and last name. Then I have one textbox labeled "full name" . Which takes the combination of the names in the three textboxes. So now, I want to split those names from the full name textbox back into their original textboxes. The only...