alt+enter

  1. S

    Line-breaks in Userforms freezes Excel

    Am using userforms on a spreadsheet to populate content to cells within a worksheet. The links are working perfectly and the data is being copied across precisely, from the userform to the cell and visa versa. However, when a line-break is added (ALT+ENTER on the worksheet / ENTER on the...
  2. 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...
  3. U

    Find then remove Alt+Enter in cells

    Hi All! I have a spreadsheet (Excel 2016 on Win 10) where certaincells in a column have multiple values entered using the Alt+Enter keycombination in a single wrapped cell. Ineed to extract those values and create separate cells for furtherprocessing. In a nutshell: “J26” = 12...
  4. G

    Find and replace

    Hi This is probably the simplest of questions. Windows 7 - Excel 2013 I have a spreadsheet extracted from a database - one of the columns holds information separated by ", " I would like this rather than in one long line to be 1 item above the next in the same cell - Find ", " and replace...
  5. L

    Split Cells with Alt-Enter to Rows

    Hi! Can anyone help me please? I have data where the last 3 Columns have multiple data in each cell using Alt+Enter. I need to split the multiple data into one row for each data and for each row the first column is copied. Please see below: I have used the Code submitted by Apo here in...
  6. M

    Looking for a formula to insert "Alt+Enter" into a cell

    Greetings to everyone, How can I convert a cell contains data separated with a comma, like this: S386006A,S386006B,S386006C,S386006D,S386006E,S386006F,S386006G,S386006H,S386006I,S386006J To a cell with data similar to using "Alt+Enter" keys, like this: S386006A S386006B S386006C S386006D...
  7. S

    alt+enter HELLLLP

    Hello All, I have a work sheet that has a column that has certain items in them that I want changed and I want the Alt+Enter function to be used. What I have: 1" 3" 1" 8" 1" What I would like: 1" (alt+Enter) 3" OR 1" (alt+enter) 8" (alt+enter) 1" I will be paying close attention to this...
  8. J

    Excel 2010 VB Help - Split Cell Data to +Rows

    Hi everybody,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> Background<o:p></o:p> We have lengthy documentation in excel 2010 which has some data wrapped (Alt-Enter) in a cell.<o:p></o:p> <o:p> </o:p> Goal<o:p></o:p> To identify and separate...
  9. S

    Alt + Enter

    Hi, I am trying to insert multiple rows into an Excel cell. I don't want to always rely on 'Alignment', 'Wrap text', and use 'alt + enter' (and have done so successfully since Excel 95 - at work). However, I haven't been able to use alt+enter for some time now on my home computer. I have had...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top