+ Reply to Thread
Results 1 to 2 of 2

show all lines in text cell

  1. #1
    Registered User
    Join Date
    08-05-2019
    Location
    SA
    MS-Off Ver
    365
    Posts
    9

    show all lines in text cell

    Good day world
    I have text in a cell that looks as of it is all in one line but as soon as you press F2 in that cell and then Enter the cell opens and you can see the text is in multiple lines
    For instance if the text is in cell E2 I have place a formula [=LEN(E2)-LEN(SUBSTITUTE(E2,CHAR(10),""))+1] in cell F2 and then the formula brings back the number 1
    As soon as I press F2 and enter in cell E2 the formula in cell F2 shows a lot more that 1, it shows all the lines that is actually in the cell

    I have tried a macro “”sentkey”” to do the F2 and Enter procedure
    But it does not work
    Is there another way to do this ?

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: show all lines in text cell

    Hi Willem

    Welcome to the forum...I am not quite sure what you are trying to achieve...Why not just double click in the cell...
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. WRAP text (show last added lines/hide first lines)
    By Jeppe88hansen in forum Outlook Formatting & Functions
    Replies: 3
    Last Post: 01-08-2018, 08:58 PM
  2. [SOLVED] Text to show in lines in a box of merged cells
    By rwalker1052 in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 12-11-2013, 04:04 AM
  3. Replies: 8
    Last Post: 01-25-2013, 11:32 AM
  4. How can I get excel to show ALL lines of wrapped text?
    By bmg in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-27-2005, 01:45 PM
  5. Cell grid lines won't show up, and have box checked
    By Fran Jones in forum Excel General
    Replies: 5
    Last Post: 09-04-2005, 04:05 PM
  6. How do I merge 3 lines of text to show in one row?
    By pita29 in forum Excel General
    Replies: 3
    Last Post: 08-06-2005, 10:05 PM
  7. [SOLVED] Wrap and merge text will not show all lines
    By jar57 in forum Excel General
    Replies: 2
    Last Post: 07-20-2005, 01:05 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1