1. G

    Paragraphs in one Cell > HTML

    Hello, am trying to convert an excel file to HTML. I have a few 100s of rows. Serial No. Name Composition 1 Destadine Syrup Each ml contains: Desratadine BP …….. 0.5 mg In a flavoured syrup base 2 Chlorphamine Each ml contains: Frech BP …….. 0.5 mg In a flavoured syrup base...
  2. S

    Create automated paragraph based on criteria.

    I do a lot of financial writing with different numbers every quarter and change language based on the date. Is there an easy way to create a form that automatically writes the paragraph summary? For example: Forthe three months ended March 31, 2019, "Company name" generated revenue of "$XXX"...
  3. S

    Print Line Number in English Reading Story with No. of Paragraph

    Good afternoon, I want to give line number of reading subject for my students. Paragraph-LineNo-para No-total lines-start no. 1-1-1-5-1 1-2-2-4-6 1-3-3-2-10 1-4-4-3-12 1-5-5-6-15 2-6-6-9-21 2-7-7-4-30 2-8-8-4-34 2-9-9-3-38 3-10-10-3-41 3-11-11-3-44 But now I just carry them by key the number...
  4. K

    Generate Summary Paragraphs

    I'm trying to design a sheet that generates a standardized summary of the results of an assessment. I've begun making formulas to do this. However, I would prefer the summary generate as formatted paragraphs, rather than as single lines as it does when written as formulas. Here's an example of...
  5. T

    Specific Paragraph from PDF to Excel using VBA

    Hi, I need to go through hundreds of PDFs on the web and extract just one Paragraph from each, and then past the sentences into one cell in Excel. I have managed to convert the pdf to txt, but it seems like the txt file does not discover the paragraph break. Do you have any idea of how I can...
  6. S

    Needing VBA script for parsing text file and returning a date

    I have multiple text files that I am having to open and record dates/times on an Excel sheet print out. I would like to have a script that can parse (read) those text files, finding certain words in a paragraph and return the date listed at the beginning of that paragraph?
  7. S

    How to extract first paragraph into excel with VBA

    Hi Friends, Been through some of the posts related to to extract data into excel. But did not find exact match to my need. I am looking to extract first paragraph of article into excel sheet using VBA. Here is sample links I am trying to. I have huge list of...
  8. A

    Find certain words (2/3/4/5 words) in a paragraph

    HI, I would like a formula that could find certain exact words ( 2 - 5 words) in a paragraph, and returns with values. Eg 3 exact words found in a paragraph, return values = 3 thanks....
  9. S

    Formatting text in Bold at CONCATENATE formula

    I typed a paragraph using CONCATENATE formula in cell (B11:I16). On that paragraph four data has been taken from other cell; (M4), (M5), (M6) & (M7) on the same sheet. I want to make Bold of the four cell text value, used in my Concatenate formula from M4, M5, M6 & M7. Need help me on my...
  10. I

    Text format to paragraphs

    We have been putting together an app for users to fi d great clubs, bars, and restaurants in london (other cities later) As part of the data entry the teams often have written descriptions as a long monologue. I want to break up the text into paragraphs. As it will be read on mobike devices i...
  11. P


    Hi, I have a in the middle of the vba code something like this Slides(1).Shapes("Rectangle 6").TextFrame.TextRange = paragraph The paragraph has 13 lines and i don't know how can I format this shape "rectangle 6" to have: Line 3 and line 9 - Bold line 4, 5, 6, 7, 10, 11, 12 and 13 -...
  12. G

    Formatting paragraph into html and copy to clipboard for email

    Hi All, I am trying to write a paragraph into vba code along with some formatting as I want to write some lines in bold, double line break, give hyperlink to email address and at the end I would like to copy entire paragraph into clipboard so I can paste it manually on email body. I am...
  13. A

    Insert paragraph using formula

    Hello, Is there any method to start a new paragraph for a long text which uses "Concatenate" within a cell. eg. =Concatenate("aaaaaaaaaaaaaaaaaaaaaaaaaaa ","bbbbbbbbbbbbbbbbbbbbbbbbbbb") I would like to get the 2nd text ie "bbbbb..." as the next paragraph within the same cell...
  14. C

    Transforming irregular paragraph-style data into Excel

    I've been tinkering with this problem for a while, but haven't been able to make much headway; I'm sure there's probably a simple solution I'm missing. I have a .txt dataset of the form; ID number Name Address1 City Tel ID number Name Address1 Address2 City that I've been trying to transform...
  15. G

    Bring big text paragraph in the cell to the new column

    here is how have articles in cell. <tbody> A B aaaaaaaaaaa(small line) (one enter is in this line) bbbbbbbbbbbbbbbbbbbbbbbbbbbbb(very big text content without enter) (one enter in this line) ccccccc(very small content) (one enter in this line) ddddddd(very...
  16. B

    split string-paragraph to cells of 30 character lengths without splitting words

    I need help to split strings/paragraphs to cells of 30 character lengths without splitting words. Any help would be highly appreciated <tbody> Original 30 len split Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam ac viverra dolor, nec facilisis metus. Maecenas nisl augue...
  17. B

    Really need help. over 20 hours spent and almost complete - WORD macro

    HI, i'm tring to find some information on my WORD doc, set a range, copy that range onto a new word doc. It seems to be working but when i check, the specific 3 digit prefix i'm looking for in the table isn't there. I also don't know how to make the macro continue where it left off after...
  18. Sniper671

    Auto copy from multiple cells into a paragraph (Concatenation?)

    I need to take data from several cells on a form-type worksheet and have it copied to another cell and/or word document in a paragraph-ish format. For instance: <tbody> Caller Name John Doe Caller Type Pharmacist Reason for Call Needs information required to fill prescriptions...
  19. A

    Transferring Q&A Transcript from Excel to Word

    So we're trying to provide our webinar registrants with a transcript of Q&As that happen within the webinar. In our registrant report, the questions and answers that each registrant asks is listed in a cell in this format: Q: Am I asking a question? A: Yes, you probably are. Q: Can I ask more...
  20. G

    Paste text into single cell

    Hi! I have a couple scripts that I would like to run on chunks of text in a single cell (A1). The problem I have is that often the text I copy has paragraph breaks so Excel likes to throw each line of text in a new row. Here is some example text: Buddy you're a boy make a big noise Playing in...

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