Preserve Line Breaks in Excel Cells

[DaveC426913]

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: :


...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 :

...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

 

[Hootenanny]

Is it possible to have line breaks within a single cell in Excel?

I've never been able to do it, not through lack of effort thought

 

[DaveC426913]

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

 

[Omega_6]

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.

 

[DaveC426913]

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.

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.

 

[Omega_6]

Well, at least it helped a little bit.
Let me know if you get it or not, or maybe go into more detail.

 

[DaveC426913]

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."

 

[Omega_6]

That was just great...

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.

::edit:: Pressing alt+enter will insert a line break within a cell.

 

[Hootenanny]

::edit:: Pressing alt+enter will insert a line break within a cell.

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

~Hoot

 

[DaveC426913]

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

~Hoot

That's the answer!

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!