paragraph

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

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

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

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

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

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?

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

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

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

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

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

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

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

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

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

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

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

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

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

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