Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Word > Excel help

  1. Apr 17, 2006 #1

    DaveC426913

    User Avatar
    Gold Member

    I need to get a Word table of postal addresses into an Excel spreadsheet.

    I want to preserve the line breaks in the original addresses. Is it possible to have line breaks within a single cell in Excel?

    From Word table:


    ....Col 1...........Col2

    R1: Bob Smith.......21 Foo St.
    ....................Toronto ON
    ....................M8Q 2S2
    R2: Biff Grunties...43 Bar St.
    ....................Toronto ON
    ....................M4V 1D8


    into Excel sheet: :approve: :approve: :approve: :approve: :


    ....Col 1...........Col2

    R1: Bob Smith.......21 Foo St.
    ....................Toronto ON
    ....................M8Q 2S2
    R2: Biff Grunties...43 Bar St.
    ....................Toronto ON
    ....................M4V 1D8


    what I'm getting now :mad: :mad: :mad: :mad: :

    ....Col 1...........Col2

    R1: Bob Smith.......21 Foo St.
    R2: ................Toronto ON
    R3: ................M8Q 2S2
    R4: Biff Grunties...43 Bar St.
    R5: ................Toronto ON
    R6: ................M4V 1D8
     
  2. jcsd
  3. Apr 17, 2006 #2

    Hootenanny

    User Avatar
    Staff Emeritus
    Science Advisor
    Gold Member

    I've never been able to do it, not through lack of effort thought :grumpy:
     
  4. Apr 17, 2006 #3

    DaveC426913

    User Avatar
    Gold Member

    Failing that, each item of data in a separate column is preferred:

    From Word table:

    ....Col 1...........Col2
    R1: Bob Smith.......21 Foo St.
    ....................Suite 700
    ...................Toronto ON
    ....................M8Q 2S2
    R2: Biff Grunties...43 Bar St.
    ....................Toronto ON
    ....................M4V 1D8
    ....................(800) 555-1212


    To Excel sheet:


    ....Col 1...........Col 2...........Col 3.......Col 4...........Col 5...........Col 6...........Col 7...........

    R1: Bob Smith.......21 Foo St.......Suite 700....................Toronto ON......M8Q 2S2
    R2: Biff Grunties...43 Bar St...................................Toronto ON......M4V 1D8.........(800) 555-1212
     
    Last edited: Apr 17, 2006
  5. Apr 17, 2006 #4
    There are a lot of ways to do this, but here is one way:

    Select the three cells that you want to merge. Right click and select format cells. Click on the alignment tab and then check the "merge cells" check box. Then click the down arrow on the vertical alignment box and choose either top, bottom, center, etc. (whatever suits your needs)

    If I completely misread your question, then I apologize.:redface:
     
  6. Apr 17, 2006 #5

    DaveC426913

    User Avatar
    Gold Member

    Gah! Is THAT where the MERGE CELLS command is! I've been looking for it!

    Thanks. That may not still not work, but it's one more club in my bag.
     
  7. Apr 17, 2006 #6
    Well, at least it helped a little bit.:smile:
    Let me know if you get it or not, or maybe go into more detail.
     
  8. Apr 17, 2006 #7

    DaveC426913

    User Avatar
    Gold Member

    Well, doesn't that just blow honkin' donkey chunks.

    Excel's idea of a merge is to keep only the data in the top-left-most cell - it displays a warning to say so. That's not a merge at all!

    Can you imagine if that *were* the definiton of merge???

    "Warning: merging traffic. Only traffic in left lane will be kept. All other traffic will explode."
     
  9. Apr 17, 2006 #8
    That was just great...:rofl:

    Anyways, I know that I've done something similar to what you are trying to do. I'll look into it later, its just been a while.:wink:

    ::edit:: Pressing alt+enter will insert a line break within a cell.
     
    Last edited: Apr 17, 2006
  10. Apr 17, 2006 #9

    Hootenanny

    User Avatar
    Staff Emeritus
    Science Advisor
    Gold Member

    That is soooo helpful, I've been trying to do a similar thing for months :grumpy:

    ~Hoot
     
  11. Apr 18, 2006 #10

    DaveC426913

    User Avatar
    Gold Member

    :approve: :approve: :approve: :approve: That's the answer!

    :mad: :mad: :mad: :mad: Too bad the requirements have changed in the meantime! Now they want each piece of data (addr1 addr2 city, prov, etc.) in its own column!
     
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Have something to add?



Similar Discussions: Word > Excel help
  1. Word help needed (Replies: 1)

Loading...