+ Post New Thread
Results 1 to 6 of 6
Office Software Thread, MS Excel find and replace CR+LF in Technical; Not sure if this has been asked anywhere and I googled almost everywhere. I know Alt+Enter in a cell will ...
  1. #1

    Join Date
    May 2008
    Location
    Kent
    Posts
    94
    Thank Post
    57
    Thanked 10 Times in 10 Posts
    Rep Power
    14

    MS Excel find and replace CR+LF

    Not sure if this has been asked anywhere and I googled almost everywhere.

    I know Alt+Enter in a cell will place a CR+LF on a line but how do you use "find and replace" to place a CR+LF in a wookbook?

    I seen solution such as Alt(010) suggested but it does not work.
    Any suggestions
    thanks

  2. Thanks to firefighting from:

    leco (21st September 2009)

  3. #2
    DrPerceptron's Avatar
    Join Date
    Dec 2008
    Location
    In a house
    Posts
    932
    Thank Post
    37
    Thanked 135 Times in 115 Posts
    Rep Power
    41
    Odd, I've just tried it here and it worked fine.

    You could try using alt+013, see if that gets you anywhere...

    VBA may possibly be able to search for vbCRLF if you wished to go down that route, but I'm not sure on the fundamentals of such a scheme.

  4. Thanks to DrPerceptron from:

    firefighting (21st September 2009)

  5. #3

    Join Date
    May 2008
    Location
    Kent
    Posts
    94
    Thank Post
    57
    Thanked 10 Times in 10 Posts
    Rep Power
    14
    I should have added Office 2007 if this makes a diffrence! I have in the past done this but for the life of me, could not remember the key strokes. I give it another try.
    thanks for replying.

  6. #4
    leco's Avatar
    Join Date
    Nov 2006
    Location
    West Yorkshire
    Posts
    2,026
    Thank Post
    595
    Thanked 125 Times in 119 Posts
    Rep Power
    41
    Quote Originally Posted by firefighting View Post
    I know Alt+Enter in a cell will place a CR+LF on a line
    I didn't know that, thanks. Will make my life in Excel much easier.

  7. #5

    Join Date
    May 2008
    Location
    Kent
    Posts
    94
    Thank Post
    57
    Thanked 10 Times in 10 Posts
    Rep Power
    14
    Have to admit it now works.
    For the record, using a laptop without a keypad was the problem. So, when the ALT key is pressed the numbers keys do not work. I didn't realise this at first.
    Workaround: use num lock or use the fn key then insert in the "Find and Replace". Hold down ALT key then "010" to get CrLf.

  8. Thanks to firefighting from:

    leco (22nd September 2009)

  9. #6

    Join Date
    Nov 2013
    Location
    Deep Umbra
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thank you!
    Good and useful informations.

    I think that a cleaner job is possible if you
    Hold down ALT key then "013" , release, and Hold down ALT key then "010"
    to get CrLf.

    I suppose that if you press only ALT+"010" you get only the LF character.
    (CR is the ALT+"013")

    A tip:
    because this characters are invisible (at least with my version of MS Excel),
    to be sure the field in the "Find & Replace" form is empty,
    you can write a random word,
    double click this word with the mouse
    (it will select all the word, hopefully with the invisible characters included),
    press DEL.
    Now you can write CR LF...

    Last edited by Myst; 20th November 2013 at 08:20 AM.

SHARE:
+ Post New Thread

Similar Threads

  1. What to replace ISA with?
    By kamikaze in forum Internet Related/Filtering/Firewall
    Replies: 7
    Last Post: 28th August 2009, 09:01 PM
  2. Find File & Replace
    By 1202 in forum Windows 7
    Replies: 0
    Last Post: 3rd May 2009, 08:15 AM
  3. CLI find & replace.
    By PiqueABoo in forum Windows
    Replies: 12
    Last Post: 23rd February 2009, 09:43 PM
  4. Time to replace?
    By cgiuk in forum Hardware
    Replies: 11
    Last Post: 24th January 2008, 08:27 AM
  5. To upgrade or replace
    By richard in forum General Chat
    Replies: 13
    Last Post: 13th March 2007, 12:54 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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