1. C

    change first letter of the text or sentence using vba

    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.
  2. W

    program won't end at the end of the last sub

    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...
  3. S

    textbox the cursor jumps to the end of the sentence

    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.
  4. D

    Linking drop down box with other cells

    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...
  5. D

    Send email outlook from Excel text spacing new lines

    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...
  6. W

    I need a formula to eneter a word in a sentence from another column

    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...
  7. B

    Assume it's easy but I can't figure out

    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>
  8. S

    Sentence cutting

    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...
  9. E

    How to combine sentences

    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...
  10. F

    Search for a single word in a sentence and output the searched value next to the correct sentence.

    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...
  11. R

    Help - How can I replace a word from a sentence and substitute the word from another cell

    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...
  12. Futile Crush

    Is this equal to ANY of these?

    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...
  13. D

    Help! Date formulas is a sentence!

    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...
  14. C

    Capitalize only the first letter in text string

    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...

Some videos you may like

This Week's Hot Topics

  • Launch Script When Tab Is Opened
    Hello all! Is there a way to launch a script or message every time a particular tab (DATA1) is selected/opened? I know it can be done when...
  • VBA that can extract words that starts with # and ends with 2021.
    Hi Everyone, I am straggling to in searching for a vba code that will extract a string that starts with # and ends with 2021. The string has no...
  • Date update overflow error ‘6’
    Dear MrExcel community, I have a project search & update & add & delete can do. There are 32 column and 5 of them is date. When I search date...
  • VLOOKUP Formula ?
    Hi i am using this below but i need to return Column C on Detailed_view. You can see ,1 this returns D, but i need to return C before D. I tried...
  • conditional formatting the whole row
    Hello This is a question solved earlier by etaf. But I am getting some problem. I need help to correct the formula as it is not working in some...
  • Vlookup in vba
    Hi, I am new with the VBA, can someone help me, I have made this macro, but the loop across files in a directory runs only in cell G13, and I...

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
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 "".
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