line break

  1. R

    Remove first blank line break in Excel using VBA

    I'm using the below script to remove only blank line breaks using Chr(10). It works great, except that it doesn't remove the line break when it occurs at the beginning of the cell. I only need it to remove the first line break carriage from the top of the cell. Sub RemoveBlankLines()...
  2. N

    find number of line feeds in a string

    Hi, I have a program where text to be displayed could be 1 or multiple lines. I want to display the text in a specific form and I have multiple forms for 1-line, 2-lines, 3-lines, etc. All good as long as I know how many lines are being required. In some cases though, I don't know that, so I...
  3. I

    What function or VBA can I use with Line Breaks in Cell

    Hello, I have tried using Index Match and Vlookup but keep getting no results. I even format to wrap and set all data to match format. I would like something similar to the screenshot below. I need a function or VBA that would pull from a cell with line breaks and output with line breaks...
  4. Z

    Macro to adjust line break in a text box

    Hi, I have below macro, what it does: It count the characters of concerned text and then add a line break whenever the text exceeds the text box size, then add this sentence "[more detail available in System]" in the last line of the text box. What I'm facing right now is: the text in text box...
  5. Z

    Carriage Return or Line Break or ALT+Enter in Cell problem

    Why Carriage Return or Line Break or ALT+Enter adding automatically in every excel cell ? is it a virus or corrupted excel software because I did not put anything its auto adding in every cell ? I have reinstall office 2013 many times and windows 7 also but same problem every time. please help...
  6. D

    Replace " </p><p>" with new line using regular expressions

    I am trying to replace " " with a new line in visual basic using regular expressions. I tried to find: ([\s]*)("") and replace with: \n\n. However, in my text is replaced but with "\n\n", not two physical new lines. I also tried to replace it with \r\r, but it does the same.
  7. M

    Help with import TXT files with transposed lines into columns

    Hey guys, I need your help with this case (sorry for the bad english :) ) I have this TXT file with payment details for each person divided by a line containing the name and year of the record, a new line with CPF number, and columns for each type of record (there are 7 colums, with headers)...
  8. M

    Splitting an Address equally in 2 columns

    Hi Everyone, First time poster, hope I am following all the rules. My dilemma right now is: I have an excel with around 3000 office addresses all in a single column, I need to split this in two (i:e, Address becomes, Address 1 and Address 2) For EG: <tbody> Address Address 1 Address 2...
  9. C

    Concatenate with a Line Break BUT....

    Hello! I have a exit interview survey that individuals are able to select multiple reasons as to why they are leaving the company. When I pull the raw data it puts all the reasons they selected into a new column. I would like to put all the reasons into one cell, which I can do using the...
  10. A

    Line breaks in text boxes linked to cell

    Hi everyone, I was wondering whether it's possible to insert line breaks into a text box's text linked via formula to a cell. For example, Cell A1: "Hello, pleased to meet you. I'd like to buy an apple" text box: =A1 -> text box displays the following with no line breaks [ Hello, pleased to...
  11. I

    How to Remove specific characters from all lines in a cell

    Good Evening every one, I've small problem in following case, your help is appreciated. In a Cell i've following data <tbody> 1. One 2. Two 3. Three </tbody> Now i want remove first 3 characters from each line and remove linebreaks and make as comma separated values. O/p ...
  12. R

    Insert a line break after every 42 characters

    Hi All, I need a formula to insert a line break after every 42 characters in a cell , example if there is 266 characters in a cell there should be 6(266/42)line breaks. =REPLACE(REPLACE(A1,42,0,CHAR(10)),84,0,CHAR(10)) I tried this but i am not sure how to get the start num to change to...
  13. R

    Combining multiple text cells into dedicated single cell, and inserting line break to separate text bulk in the dedicated single cell?

    Hello, I need to combine multiple product description texts which are in their own cells into a one single dedicated overall description cell which will encompass all the bulk texts from those separate cells, however not make all the text flow in single string without line breaks. Required...
  14. R

    Macro to insert a Line break at the end of the text of the cell in excel file

    Hello, To manually insert a line break at the end of the text of the cell in excel file the solution is "ALT + Enter" But I like to create a macro in the excel file which will do same but to the entire column. Thanks, Ram
  15. H

    Format word wrap/breaks to appear as separate row in sheet

    I have an excel sheet that is exported from an access report. The excel file automatically resizes columns and wraps text, etc. One of the columns on this sheet contains about a paragraph's worth of information. My question is: is it possible to somehow format all cells in this (or all)...
  16. P

    Conditional Format STOPS at linefeed (line feed, line break)

    In 2003 Conditional Format would format (font) the whole cell. It appears that 2010 stops the formatting after a linefeed? Is this right? ie. is it my configuration/system? Is it configurable? Is there a workaround? Thanks very much.
  17. K

    Remove line break for the last line only

    Hi, I wondered if anyone could help with my query. I have an excel spreadsheet that is produced by a report that pulls address into one of the columns that I use for a mailmerge. The problem is that at the end of almost all of these addresses there is an additional line break at the end or...
  18. N

    Formatting Addresses using line breaks

    I have a spreadsheet with address information, with columns for Address Line 1, Address Line 2, City, State, and ZIP. I'd like to combine each of the columns into a single, formatted column, with line breaks in the address as follows: Address Line 1 (break) Address Line 2 (break) City, State...
  19. G

    Force line break in label that is concatenated

    Dear All, I have a cell where I am stringing text together and want to force a line break/carriage return in the label. I know that if I was purely entering text, I can hit ALT+Enter within the text to force a line break. How do I accomplish this when the text is created using concatenation...
  20. B

    Add Line Break

    Hi guys, I'm creating a template in excel to automate an e-mail that has to be sent out to different customers. I'm pretty much just using the ''&'' function to add individual information to generic text. What I would like to do is have it start off like this: ''Dear Mr. Brown, Please find...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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 MrExcel.com.
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 "mrexcel.com".
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
Top