alt-enter

  1. T

    Line Feed from toolbar

    Is there a toolbar ribbon method to put a linefeed within a cell? I have a user who wants multiple lines within the same cell. Unfortunately our users access Excel through Citrix, so the standard ALT-ENTER command is unavailable. ... it actually logs them out. Using Wrap text won't work...
  2. D

    alt-enter in an inputBox

    Hi all, I have a macro that combine data from a column into a cell. The macro ask to enter a separator in an inputBox and then combine all the data from a column range in a cell separated by the separator of interest. Now I want to combine my data in selection with "alt-enter". I am not sure...
  3. D

    Clean and Trim Data from a column without removing alt-enter.

    Hey, As my last post regarding is not addressed I am posting this again. I want to clean (removing non-printable character) and trim (removing extra spaces at the beginning and end) my data in selection within a column. As the clean function also remove alt-enter, I want alt-enter to be...
  4. D

    Clean and Trim data from a column

    Hi, I am trying to clean or trim my data in a column. My objective is to remove all non-printable characters and also the leading and tailing extra spaces or the ALT-enters. The code I have written also removes ALT-enters in the middle of the data :(. Please find my code below: Sub CleanTrim()...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top