+ Reply to Thread
Results 1 to 3 of 3

Reversal of Alt+Enter

Hybrid View

HerryMarkowitz Reversal of Alt+Enter 11-23-2013, 05:09 PM
jindon Re: Reversal of Alt+Enter 11-23-2013, 05:16 PM
HerryMarkowitz Re: Reversal of Alt+Enter 11-23-2013, 05:18 PM
  1. 11-23-2013, 05:09 PM #1
    HerryMarkowitz is offline
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,014

    Reversal of Alt+Enter

    Hi forum expert,

    Run the following code; 
    Sub Makro1()
Range("A1").FormulaR1C1 = "Best" & Chr(10) & "Excel" & Chr(10) & "Forum"
End Sub

    How can I make A1 cell value
    from,
    Best
    Excel
    Forum
    to,
    Best Excel Forum ?
    Last edited by HerryMarkowitz; 11-23-2013 at 05:39 PM.
    Reply With QuoteRegister To Reply
  2. 11-23-2013, 05:16 PM #2
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Reversal of Alt+Enter

    One way
    Range("A1").Value = Replace(Range("A1").Value, vbLf, "")
    Reply With QuoteRegister To Reply
  3. 11-23-2013, 05:18 PM #3
    HerryMarkowitz is offline
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,014

    Re: Reversal of Alt+Enter

    Perfect. Thank you very much.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Reversal of Percentages?
    By DECROMAX in forum Excel General
    Replies: 4
    Last Post: 07-25-2010, 06:50 PM
  2. Date Reversal
    By Mizery in forum Excel General
    Replies: 8
    Last Post: 08-20-2008, 01:20 PM
  3. [SOLVED] Line Chart Axis Reversal
    By AdamP in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-11-2006, 01:10 PM
  4. Data Order Reversal
    By chris_manning in forum Excel General
    Replies: 3
    Last Post: 07-11-2005, 11:05 PM
  5. byte order reversal in spreadsheet
    By CuriousMark in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-22-2005, 04:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1