Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Jan 2008
    Location
    Wheaton, Illinois, USA
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a list in Word with addresses, which are multi-line. When pasting into Excel, they divided each line into its own cell. I am open to other routes to do this, but so far, this was my intent:

    In Word, I replacing hard returns with semicolons, which put the address text together into its own cell. I was going to do a Find-Replace but can't find the the replace symbol (in the dialog box). Using Excel 2007 (Compatibility Mode).

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Chicago, Illinois, USA
    Posts
    187
    Thanks
    6
    Thanked 0 Times in 0 Posts
    try using char(010)

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post
    [quote name='halfmybrain' post='772913' date='29-Apr-2009 17:38']I have a list in Word with addresses, which are multi-line. When pasting into Excel, they divided each line into its own cell. I am open to other routes to do this, but so far, this was my intent:

    In Word, I replacing hard returns with semicolons, which put the address text together into its own cell. I was going to do a Find-Replace but can't find the the replace symbol (in the dialog box). Using Excel 2007 (Compatibility Mode).[/quote]

    To replace the carriage return (or pilcrow) use the following in the Find and replace

    Find ^p
    Replace ;
    Jerry

  4. #4
    2 Star Lounger
    Join Date
    Jan 2008
    Location
    Wheaton, Illinois, USA
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I tried that, it doesn't work. It just inserts the actual characters ^p into the text.
    There used to be a drop-down box in the Find-Replace dialog, with this option.
    I don't see it now.


    [quote name='Jezza' post='772918' date='29-Apr-2009 17:14']To replace the carriage return (or pilcrow) use the following in the Find and replace

    Find ^p
    Replace ;[/quote]

  5. #5
    2 Star Lounger
    Join Date
    Jan 2008
    Location
    Wheaton, Illinois, USA
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts
    That didn't work, it simply put char(010) into the text.

    [quote name='Zeno' post='772915' date='29-Apr-2009 16:43']try using char(010)[/quote]

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Assuming that you already replaced line breaks and/or paragraph breaks in Word with semi-colons, enter the following in the Replace dialog in Excel.

    Find what: ;
    Replace with: Alt+010

    Then click Replace All.

    You must turn on Wrap Text in the Alignment section of the Home tab of the ribbon.

    (If you wanted to know how to do something in Word, you should ask in the Word forum)

  7. #7
    2 Star Lounger
    Join Date
    Jan 2008
    Location
    Wheaton, Illinois, USA
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Worked fine! My problem was in my target, Excel; not my source, Word.

    [quote name='HansV' post='772933' date='29-Apr-2009 18:40']Assuming that you already replaced line breaks and/or paragraph breaks in Word with semi-colons, enter the following in the Replace dialog in Excel.

    Find what: ;
    Replace with: Alt+010

    Then click Replace All.

    You must turn on Wrap Text in the Alignment section of the Home tab of the ribbon.

    (If you wanted to know how to do something in Word, you should ask in the Word forum)[/quote]

Posting Permissions

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