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

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top