sentence

Hi All, can any one please help me get the below result in excel ? Sentence : <tbody> Again, this company is the best and pioneer on the trend. This is the reason why I will recommend this company. </tbody> From the above sentence, if i find the word company, i need to extract 2 words...

1. I am looking for a script to count the number of words in a sentence from a word file. 2. Also to count number of words in a given cell in Excel Thanks for your attention Kelly

hi all are there any syntax of how to change only the first word of the text or sentence to upper cap format using vba? so far in vba excel, there are only all lower cap, all upper cap and proper sentence.

I have an foreign language learning program. Simplified a little, on a user form I designate a verb, e.g., “buy” and click “start.” A sub randomly selects a person, e.g., “I”, “you,” or “they,” puts the English in cell (2, 2) and the Italian in cell (3, 2), and then calls a sub named...

Hi All, The TextBox on User form gets a value from worksheet cell. When I want to edit a text, the cursor jumps to the end of the sentence. any idea ? (Excel 2007) Thank you in advance.

Hello, I am brand new to this forum, so thank you for letting me join! I had a question that I just cannot seem to figure out. I have some knowledge of excel but I find it hard to navigate through VLookup which is what I think I may need for what I am trying to do. Essentially, I have a drop...

Hi, I have a macro to send a pre-written message in the body of the email. I am using .body in the script in VBA....does anyone know how to create new lines and paragraphs in the text so it does not appear as one big long sentence. So I want it to appear in the email as Hi Please find...

Good Day, I have in column "C" the following word "Wimpey Chairs" and in column "DR" I have the following sentence " <tbody> Shop at Office Stock, carrying a huge selection of quality furniture and office supplies." So I am looking for a formula where I can enter the words in column "C" in the...

Can I have a value inserted into a sentence? "If you are selling under the name of<insert data="" from="" a2="">,(data from a2) please select one" Thank you in advance.</insert>

Hello, I was wondering if there is a way to cut words from sentences ? My problem is that i have information that is in one cell and i need to cut it apart in different cells. I could do it manualy but there are thousands of sheets like this. Example Johan dohan, snippersnapper, jorgen 21...

Hi all, I have a large file with list of 6,000 rows (on column A). I want to do this thing: If the first character is not a number ,I want to continue the sentence above it etc... For example: I have this: 1. Bristol 2. Edinburgh 3. Cardiff 4. Liverpool else 5. Leeds 6. Manchester 7...

Hi there, first post. I'm knees deep in excel these days, but unfortunately not overtly talented (yet). I have the following issue: Two columns: A = one with a set of 1500 keywords B = 25000 sentences of text C = the output (which should also be the keyword) I need to search the sentences...

How can I replace a word from a sentence in a cell and substitute the word from another cell. example: A1 > apple A2 > banana A3 > carrot . . A100 > grape B1 > I ate food this morning (using ONLY cell B1 as source of sentence) **this is the OUTPUT after replacing word "food" C1 > I ate apple...

Hey guys, I wanted to know how to find out if the value in one cell equals any one of an item in a list, without using a tedious OR formula for everything or VBA code. If there's any way to do this, I'd be greatly appreciative for you to let me know. :). Just to clarify, or give an example...

Need to know the formula for a cell to read <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> “August 20, 2008 through February 20, 2009” <o:p> </o:p> Need dates to auto changed based on todays date. The last date being todays date and the first being the...

In Excel 2003, I am referencing a text string and would like to return the text string with only the first letter capitalized. The PROPER function does not do this, as it capitalizes the first letter of every word. The formula below does however perform this, but I would like to write it as a...