First, you should know that Excel contains two functions, CLEAN and TRIM, that can automatically remove line breaks and extra spaces from text. First, highlight a few passages or lines in a Word document with the cursor. Finally, the cmdOK_Click procedure must transfer the values held in the variables above, and those entered into the other textboxes and combo boxes, to the bookmarks in the letter document. Cleaning up text pasted from emails or Web sites. Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013. Microsoft introduced Split function with VBA Version 6 (in Office 2000). So you can format different sections in distinctive styles. Be aware that with every new option included this function becomes slower. (Remember, macro commands by definition are one per line. The lines were actually data coming from a database where per line comes from. Replacement. Most of the time, you will probably need to split cells in Excel without having to use any advanced feature. without the pre tag -- it'll wrap it as it (the browser) wants. Enter a New Line. Sometimes when you are using Word and you enter three dashes in a row on an empty line, it draws a horizontal line across the screen. You can’t delete automatically inserted page breaks. If you are not using our software and get the above message, it means that your code is referring to something that does not exist or no longer exists. Here's how… (this works in both Word 2003 and Word 2007) Press Ctrl+H to open Word's Find and Replace dialog box. Select Cell or Range and this will remove All Line Breaks from the Left and Right, and removes any blank lines. Be aware that with every new option included this function becomes slower. Line break mark or represents the place where line breaks and text starts in the next line. However, if you have a dataset where the delimiter is a line break (in the same cell), it gets tricky to split these multiple lines in the same cell into separate cells/columns. The Split function will then search for 1 space between each word of the text, and break it into chunks where this space is found. Again, this works ok in the body of the document by simply using vbCr's for line breaks. Problems occur when extra returns are inserted in a document instead of using the formatting options to specify the spacing between paragraphs or lines of text. Lets see how this is done. Text = "^b". net excel,word,pdf component. Deleting section breaks can mess up page orientation and/or headers/footer. A way to semi-automate removing line breaks from text we paste into MS Word. A Range object represents a continuous area in a document. In the WordWriter template document, insert a line break within the AddressLine2 data marker itself: Right-click on the AddressLine2 merge field. VBA programming: Part I 7 ActiveDocument. You can’t delete automatically inserted page breaks. VBA write to text file carriage return Excel Macros Examples for writing to text files using VBA in MS Office Word, PowerPoint, Access, Excel 2003, 2007, 2010, 2013 and VBScript. After this problem, I usually encounter the arbitrary paragraph or line breaks. Click Replace All to convert all the hard line breaks onto spaces. Instead, insert the line break only when the AddressLine2 is present. Replacement. The ease of copying and pasting text from Web sites and email greatly simplifies many tasks in Word, but problems often arise in making the pasted text conform to the style of the document into which it is pasted. So I finally put this together from all the forums. When you save this workbook, the Stop statement will be saved with it. Remove Spaces from Text Home Health and Fitness Math Randomness Sports Text Tools Time and Date Webmaster Tools Miscellaneous Hash and Checksum ☰ Online Tools and Calculators > Text Tools > Remove Spaces. Once you know the special codes you can just type them; but the Special button is invaluable at first!. So, the field will have text, the little square box and more text. Definition Of Manual Page Break In Microsoft Word Macro Read/Download Word Online (formerly Word Web App) extends your Microsoft Word experience to the web Insert page breaks in both Word Online and the Word desktop app. How this formula works. Hi all, I know when I do data entry, I can force a line break in a text box by using Control & Enter. The line below colores the cell green. Dim s As String = "C:\Users\Sam\Documents\Perls\Main" ' Split the string on the backslash character. You can do this with a macro very easily. Enter a New Line. Click Developer > Visual Basic or press Alt+F11 keys to open the Microsoft Visual Basic for applications window, then click Insert > Module, and input the following code:. Basically the model has objects. All we need to do is manually add single line spaces by using control+return (PC) or shift+return (Mac) after each line break. How to Remove Page breaks in C# In Word document, users can add new page break or remove existing page breaks. if you want to remove all the vbLf (Char(10)) and vbCr (Char(13)) in your tring, you can do it like that:. Remove Spaces from Text Home Health and Fitness Math Randomness Sports Text Tools Time and Date Webmaster Tools Miscellaneous Hash and Checksum ☰ Online Tools and Calculators > Text Tools > Remove Spaces. A String object is a sequential collection of System. Delete line breaks using formulas to employ several formulas for a complex cell text processing. If you see anything problematic, shoot me mail (CustomerSupport@AskWoody. vbLf is the built-in constant for the line feed in VBA. How the increasing amount of data around forces users to search for the most effective ways to consume it. MsgBox function in VBA displays a message in a window and waits for click on a button. vbLf is Chr (10) and means that the cursor jumps one line lower (typewriter: turn the roller) vbCr is Chr (13) means the cursor jumps to the beginning (typewriter: pull back the roll) In DOS, a line break is always VBCrLf or Chr (13) & Chr (10), in files anyway, but e. If you move the insertion point up to one of those section break lines (i. Im working it but am on a time crunch if anyone has anything that remove blank lines in Word Doc - VBA Visual Basic for Applications (Microsoft) - Tek-Tips. Select the Line and Page Breaks tab. without the pre tag -- it'll wrap it as it (the browser) wants. Re: Remove trailing Carriage Returns from text I know this post is very old but I could not find anything that would do this. Even though the signature looks correct (i. Don't delete the page to remove line breaks in Word, instead use these tricks to remove line breaks. Remove new line from a string. VBA programming: Part I 7 ActiveDocument. You can use Chr(13) which is an old style character conversion of ASCII character 13 which is the carriage return and line feed character. There are plenty of other operations that you can execute in the code window. Using this is like using a conditional breakpoint. Insert Word Page Break in Document in C#, VB. In this guide, a solution will be presented to remove Word section in C# and VB. which replaces line breaks in B5 with commas. ) and it all works great. VBA macro to get rid of line breaks. Repeat this step as necessary until the whole SQL statement is on one, long line in the code. You can add or remove page breaks in Microsoft Word in a number of ways. vbVerticalTab used at the end of line three emulates Shift+Enter (also known as manual line break, soft return). When you execute the code above, the code pauses at the line where Stop is. p( replace( l_text, chr(10), '. Optionally, you can replace the original column with the one where the line breaks were removed: Select all cells in column C and press Ctrl + C to copy the data to clipboard. Line breaks are different than most of the tags we have seen so far. I'm regularly annoyed at password-protected Microsoft Word files that only permit editing of certain aspects of the document such as form fields. Problems occur when extra returns are inserted in a document instead of using the formatting options to specify the spacing between paragraphs or lines of text. tag and the line break itself gets remove so the data is just one long line? I'm trying to highlight/copy the cell, paste it into a form so it would output like the example below ----- Hi yahoo users,. The trick to deleting this line (in Office 2007 at least) is to. Write code to add the reference back. This code was written for Word 97 and worked fine for Word 2000. Press the "More" button -- which changes to "Less" after you click it -- to open additional options. Don't delete the page to remove line breaks in Word, instead use these tricks to remove line breaks. For example, some paragraphs may be single spaced and some double-spaced. Recently I received a report from a HR system which is claimed to be a standard report. UiPath Activities are the building blocks of automation projects. Title Keywords ; HowTo: Use regular expressions and LINQ to list the unique words contained in a text file in Visual Basic. , single-spaced) in Outlook's signature editor (and even in Word, where I added some hyperlinks), the mystery line breaks appear whenever I create a. Optionally, you can replace the original column with the one where the line breaks were removed: Select all cells in column C and press Ctrl + C to copy the data to clipboard. I wanted to be able to insert a row and maintain the formulas but not to copy data that would be unique for the line. This function will work in all the versions from old to new i. You need to use the SUBSTITUTE function to remove all line break characters in the text in a cell, then using the LEN function to get the length of the text without line break characters. Sometimes it’s necessary to have more than one line inside a worksheet cell, which is easily done with a line break. On the Security Level tab, set the security level to Medium, so that you have the choice of enabling your macros. My solution assumes you're using MS Word 2016. In many cases a macro command line extends beyond the width of the screen and you desire to break the macro into two or more lines in order to see it all on the screen at one time. The Like operator is an easier alternative to VBA Regex which allows you to search for almost any pattern within a string and find matches. Excel VBA delimit Cell value into rows. What can you do with Remove Empty Lines? This will remove empty lines from provided text or input string. Word 2013 and Word 2010 offer similar special character options. Remove all carriage returns manually to quickly delete line breaks in 1 worksheet. which replaces line breaks in B5 with commas. In MS Word, if you type three dashes in a row, and tap the Enter key, a horizontal line is inserted in its place. what is the code for searching for and removing a blank line in a multi-line text box? im using VB Express '08 and can not figure it out. vbCritical 16 Displays Critical. You can insert line break by pressing Shift+Enter. Frequently (due to improperly inputted information), there is a random line break in the middle of a cell, resulting in data that should be in columns Q (or R or S) - AP winding up in columns A thru Y (or Z or AA). Add Prefix/Suffix into Line; Add/Remove Line Breaks; Add Repeats Tool; Count Characters, Words, Sentences, Lines; Delimited Column Extractor; Find and Replace Text; Letter Case Converter; Join/Merge Text (Line by Line) Remove Duplicate Lines; Remove Duplicate Words; Remove Empty Lines; Remove Extra Spaces; Remove Letter Accents; Remove Lines. How to Insert a Line Break in MS Word. VBA will run the code until it reaches the STOP statement, then allow you to step through your code line by line. Sometimes we need to get the total number of pages in a Word document when we make a macro. You can then step through the code (F8) or continue execution (F5). rtf document into HTML code. I need to abstract this data into an excel file that breaks down each field into a different column. tags appearing in the cells. Today, in a forum question , the subject resurfaced so I dug up my function and am posting it here should it might serve someone else. also with the text boxes in VB. " Of course, it's never a good strategy to tell your customers that the problem is on their end and that they need to do something to fix the problem. I have a string that I print out to console in one line but there is some kind of special character in my string so that VisualStudio 2010 interprets is as a line break. gif below and excel file in the same folder for testing it. Here is a useful trick to quickly resolve this without having to remove all the line breaks manually. How to Insert a Line Break in MS Word. Re: Remove trailing Carriage Returns from text I know this post is very old but I could not find anything that would do this. Finally, return to the Replace box one more time. Word's optional break character offers a helpful workaround that lets you, not Word, control the break. CTRL+Z Undo the last editing action in the current line. Here, in this article I’ll show you how to Split text or values with Carriage Returns to multiple columns using VBA. Section breaks are inserted by creating a SectionProperties element within a Paragraph element. Inserts the text at the beginning of the current selection. My next update to this routine will be to handle changing printer settings and. Move to a new position All members attended who were new. p( replace( l_text, chr(10), '. body { line-height: 1. Sometimes we need to get the total number of pages in a Word document when we make a macro. Now you can reset or remove a password from a Word, Excel, or PowerPoint file—with Office 2013!. The fix is usually simple -- although the cause might surprise you. Breaks are useful if you want to break up an idea or set an image apart from text in your document. My problem is that I don't know how to use RegEx to make it only remove the ^p tags in word or CRLF or line breaks in any format under the conditions that it omits ones following a period. Word 2016 Keyboard Shortcuts Keyboard shortcuts allow you to perform actions using only your keyboard that otherwise you would perform with your mouse. Place this new chart over the old chart: Also, insert the marker (though Insert >Shapes) as to show a break between the. You have some text. I have learned more about VBA than I could have imagined. Random number generator; Random string generator; Shuffle letters; Clean text; Barcode generator; Compress; Text statistics; Remove line breaks; Add line breaks; Add line break. (Remember, macro commands by definition are one per line. However, if you have a dataset where the delimiter is a line break (in the same cell), it gets tricky to split these multiple lines in the same cell into separate cells/columns. Two of the most common characters you will find yourself searching for are paragraph marks and line breaks (sometimes called newline characters). They enable you to perform all sort of actions ranging from reading PDF, Excel, or Word documents and working with databases or terminals, to sending HTTP requests and monitoring user events. Below is an example of a Word document with too many blank lines: However, it can be centuries after you finishing removing these blank lines one by one. Then Trim it all to look good. HorizontalAlignment = xlCenterAcrossSelection. The default value is wdPageBreak. How can I do it in Excel for Mac? Is there a way to represent the line break within the Excel "Replace" tool, just like ^p in the Word "Replace" tool?. Ctrl + Shift + T Remove hanging indent from paragraph Ctrl + M, then Ctrl + Shift + T Create "traditional" first line indent of 0. Basically the model has objects. Unfortunately, you have paragraph breaks, not line breaks. To make the sentence proper we use "new paragraph" or new line as one of the techniques and this usually happens in Word document. The fix is usually simple -- although the cause might surprise you. Spaces, line breaks, dashes and other characters make data more readable to us frail humans, but when it comes to parsing data from various sources in Excel, getting the formatting nice and. stet Let stand Remove the battery cables. By itself, Word's "Restricted Editing" isn't necessarily a bad thing. Near the bottom left of the dialog, select the Regular Expressions check box. First, on the Home tab click the Paragraph icon to show all characters. There are severl characters that act as line break. If we want to remove all the spaces, we can use the Substitute function. Learn Breaks in MS Word, How to use Breaks in Word, Section Breaks, Different Section breaks in Word, VBA code sample of Breaks and Section. A find and replace of Chr(10) should do the trick on a MAC too. For example, my file includes below lines: "This is the first line // blank lines. Insert or change an Outlook signature using VBA - use the dim strBuffer to the signature close line code in your code above (you can put it before setting outlook object) then change the html body line to. Re: Delete blank line breaks in a cell Yes, I copied the data from above to try it out - there are a few spaces on the blank rows, so it needs a bit more fiddling with manually. (This is only temporary. Recently, I copied some text from a web site into a word and found that there is large number of unwanted line breaks in the document. In Word 2010, Microsoft's object model help says that the AllowPageBreaks property is 'Hidden' and that 'Hidden' means "The member has been deprecated and is not recommended for use in code. Remove line breaks, return carriages, and all leading space in Excel Cell The only way to remove these characters it to get the cell active, click delete near the. Instead of “Find”, use the “Replace” tab of the search window and replace them with a blank space (” “). I'm regularly annoyed at password-protected Microsoft Word files that only permit editing of certain aspects of the document such as form fields. Press CTRL + H to open the Find/Replace box 2. And yes, you're absolutely right: the ^m is Word's syntax for a manual page break. You can't remove automatic page breaks, but you can adjust where they occur. Each of these word are different, but contains the same characters. The following VBA code can also help you to delete all of line breaks in a worksheet. How to Insert a Line Break in MS Word. com) and I’ll try to fix it. This article explains how to add and remove hyphenation in a Word document, and how to work with the options you have in the hyphenation menu. Below is an example of a Word document with too many blank lines: However, it can be centuries after you finishing removing these blank lines one by one. Select the cell with the line break in the formula, and on the Ribbon's Home tab, click the Wrap Text. I want to be able to remove these characters, but keep the rest of the text intact. macro to delete line break Word VBA. After importing my spreadsheet, all my line breaks appear as " " and the text all runs together (no line breaks) in the table. SendMail() •Runs the default email program •The active document automatically becomes an attachment •Subject line = name of document •(For anything more fancy you should use VBA to create and access an MS-Outlook object) Closing Documents •Default action when closing a MS-Word document that has. If there are any line breaks, we can use "Clean" function, but it will not remove additional spaces but just remove line breaks. After completing the Udemy course I purchase Modules 1 and 2 of His VBA Handbook and completed the exercises. Lets see how this is done. The macro will delete the manually inserted page breaks in the document. Add a new line in Excel cell on Mac computers by holding down the Alt key while you press enter. If you remove all of the paragraph breaks, the whole document becomes one paragraph, possibly exceeding the 64K character limit for a paragraph. The uncommon line break is Chr(13). In Excel 2008 and 2011 for Mac use Cmd+Option+Enter. Delete a stubborn page break in Word by Susan Harkins in Microsoft Office , in Software on January 7, 2010, 11:13 PM PST Sometimes, Word won't let you delete a page break. The application in this particular article is divided into two methods based on the button that is pressed in. And the word "page break" is inside the line which implies to me that this is a manual page break. Two of the most common characters you will find yourself searching for are paragraph marks and line breaks (sometimes called newline characters). com) and I’ll try to fix it. The characters_to_remove may include special characters such as tabs `t , new lines `n or carriage returns `r. More or less this is done so you can easily see the effect of the code but it’s also there for practical reasons. A find and replace of Chr(10) should do the trick on a MAC too. DisplayPageBreaks = False Page Break lines will appear again and this box will get checked when you print or use print preview. For more information on how to delete line breaks from from text in Excel, please see: https://www. Re: Delete blank line breaks in a cell Yes, I copied the data from above to try it out - there are a few spaces on the blank rows, so it needs a bit more fiddling with manually. Regex Pattern for Parsing CSV files with Embedded commas, double quotes and line breaks Tuesday, October 14, 2008 at 5:32AM While you have stumbled on KimGentes. In Word (Windows or Mac), I can easily replace all the | with a line break (^p). How do I delete a line break in Microsoft Word? show up in Micorsoft Word documents. Remove new line from a string. turn off in VBA: ActiveSheet. You can remove line breaks from blocks of text but preserve paragraph breaks with this tool. How to add and remove horizontal lines between sections of the document Word 2016 2013 2010 2007 2003 Word proposes very simple way to add horizontal lines to a document, but if you would like to remove these lines this wouldn't be so obvious. Aligning the sentence is very important to covey proper message to the users or readers. Here is an example of what I am up against. How do I make Microsoft Word only go down one line when I press the return key? Are you sure that you want to delete this answer? If you want a line break. Please do as this: 1. VBA Loading form/Progress bar/Animated GIF…. Click on the More Options button to open the full dialog. By default trim() will remove leading and trailing spaces and leading and trailing line breaks. One other thought: While deleting a page this way will work, "page" is seldom a logical part of a Word document unless you are using manual page breaks. , up to the character code 12) and delete it, you are deleting the section that. How can I do it in Excel for Mac? Is there a way to represent the line break within the Excel "Replace" tool, just like ^p in the Word "Replace" tool?. Here are the steps to follow when you want to insert, move, or delete page breaks in a Microsoft Excel worksheet. I seem to be able to add them, but deleting them is impossible. my problem is im loading a sample. How this formula works. I have to deal with such excel files which are converted from pdf or are downloaded from internet. English, for example) that you have selected or installed. Section breaks are useful in creating multiple sections in Word document. It functions as a Line Break/alt enter key/Carriage return key, allowing your next cell value to go to the next line. Another line. T his Microsoft Word Tips & Microsoft Word Help page is provided for aspiring VBA (Visual Basic for Applications) enthusiasts as a collection of VBA Basics. They enable you to perform all sort of actions ranging from reading PDF, Excel, or Word documents and working with databases or terminals, to sending HTTP requests and monitoring user events. By default trim() will remove leading and trailing spaces and leading and trailing line breaks. Highlight the entire table 2. This little macro solves this problem. Now anything you type, open, delete, or format, will get recorded in VBA, so you have a clue how to write your Word Interoperability code. If you want to add the job title and company name to the layout and remove the country name, type (or copy and paste) this into Word, with a carriage return after each line:. My problem is that if I use a vbCr in a Word Table, it interprets the vbCr as an unprintable character and displays an empty square character!. " Of course, it's never a good strategy to tell your customers that the problem is on their end and that they need to do something to fix the problem. Basically the model has objects. P > B > R) Note: Automatic page breaks cannot be deleted. put the cursor over the left hand edge of the break line it will turn black 4. This is represented by CHAR(160):. Note When you insert a section break, the break is inserted immediately preceding the selection. press delete. No problems when you run the code in Excel 2007-2016. Word's optional break character offers a helpful workaround that lets you, not Word, control the break. In Word (Windows or Mac), I can easily replace all the | with a line break (^p). Place this new chart over the old chart: Also, insert the marker (though Insert >Shapes) as to show a break between the. Here is an example of what I am up against. Random number generator; Random string generator; Shuffle letters; Clean text; Barcode generator; Compress; Text statistics; Remove line breaks; Add line breaks; Add line break. XlsxWriter is a Python module that can be used to write text, numbers, formulas and hyperlinks to multiple worksheets in an Excel 2007+ XLSX file. within the code is the same as pressing the return key in a word processor. Where three or more VBA line breaks follow each other one after another, I have to reduce each group of three, four, or five Chr(10)s to just two at a time, leaving a standard single-line space between each paragraphs. After this, use the keyboard shortcut ALT + ENTER. Section breaks are useful in creating multiple sections in Word document. Describes the behavior when line breaks are removed in a plain text format post without any indication in Outlook. Here we will prepare two methods to find this feature in Microsoft Excel 2007, 2010, 2013, 2016, 2019 and 365 for you:. Highlight the entire table 2. When I select the references list at the end of the document and run the macro, it seems to remove all line breaks. Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013. Interestingly enough, the combination of these two functions is integrated into the ENTER/RETURN key. Select the row below or column to the right of the page break and perform these steps: Under the Page Layout Ribbon Menu, select Breaks then Remove Page Break (ALT > P > B > R) Note: Automatic page breaks cannot be deleted. To insert a new paragraph, press the Enter key. Today, in a forum question , the subject resurfaced so I dug up my function and am posting it here should it might serve someone else. How do I remove line breaks in my Excel file? General questions Updated on September 9, 2019 If you have a list of contacts in your Excel file with the first and last name appearing on two separate lines (example below), you'll want to edit the file so that the first and last name all appear on one line, removing the line break from the cells. Basically all it does is automatically replace all the unwanted line breaks with a single space, making all the text run together into a single paragraph: copy the text you want from the PDF; paste into a new Word document. That's because the beginning of any other line is affected by the layout parameters returned by the attached printer's driver - and that varies from one printer make/model to the next. New Line in VBA MsgBox. Describes the behavior when line breaks are removed in a plain text format post without any indication in Outlook. Section breaks are useful in creating multiple sections in Word document. The result of the concatenation is text with line breaks: Traci Brown¬ 1301 Robinson Court¬ Saginaw, MI 48607. This example inserts text at the end of the selection and then collapses the selection to an insertion point. Click "More" at the bottom 3. There are severl characters that act as line break. Recently our company uploaded employee data in spreadsheet data to the new system. text file and using txtFile. However, there can be complications. ¶ New paragraph The box is full. In case you want to not only find check if the string contains a substring but also return the position of the match – best try using the VBA InStr function. Learn Excel from top-rated instructors. VBA, Word Table Insert/Remove Rows/Columns Aug 26, 2015 by azurous in Tables In this article I will explain how you can add and delete rows and columns from tables in a word document using VBA. " & strBuffer - remove the extra paragraph if needed. DELETE or DEL Delete the selected text without placing it on the Clipboard. This Access / Excel tutorial explains how to remove carriage return and remove line break in a text. Cleaning up text pasted from emails or Web sites. How to add and remove horizontal lines between sections of the document Word 2016 2013 2010 2007 2003 Word proposes very simple way to add horizontal lines to a document, but if you would like to remove these lines this wouldn't be so obvious. Click End to end the macro, click Debug to take a look at the macro in the Visual Basic Editor. Sometimes we need to get the total number of pages in a Word document when we make a macro. Access Excel remove carriage return and remove line break. You can workaround this behavior by disabling the Auto Remove Line Breaks feature. WrapText property returns or sets a Variant value that indicates if Excel wraps the text in a cell. Don't delete the page to remove line breaks in Word, instead use these tricks to remove line breaks. Each range object is defined by a starting and ending character position. Finally, the cmdOK_Click procedure must transfer the values held in the variables above, and those entered into the other textboxes and combo boxes, to the bookmarks in the letter document. Very similar to search for line breaks you can also remove or replace them. Section breaks are useful in creating multiple sections in Word document. When you execute the code above, the code pauses at the line where Stop is. In this guide, a solution will be presented to remove Word section in C# and VB. CTRL+BACKSPACE Delete to the beginning of the word. Advertise on Tizag. The Line Feed is represented by ASCII number 10, and it harkens back to the action of a typewriter rolling a piece of paper up by one line. also with the text boxes in VB. Using that code you can now show or hide "Page Breaks" on the active sheet with a macro. Text = "^b". Wow, thank you for your detailed response and the macro Graham. VBA Code Removing Section Breaks. Today, in a forum question , the subject resurfaced so I dug up my function and am posting it here should it might serve someone else. After running these lines of code the whole document will be selected. Inserting multiple lines in a VBA message box. Really, there is no line break, so be sure to place it all into the Immediate window on one continuous line as shown in the next picture: Finally, with the cursor in the Immediate window, and blinking somewhere in or on that line of code you typed or copied and pasted, hit the Enter key. Removing each of them manually would be very time consuming. DizData is just a string variable, but I'm sure you could use it in your comment copying code.