I need Help! Badly! How to split a single cell into multiple rows!

SariJo10

New Member
Joined
Aug 19, 2009
Messages
10
****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 11">****** name="Originator" content="Microsoft Word 11"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5CSarahJo%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml"><link rel="Edit-Time-Data" href="file:///C:%5CDOCUME%7E1%5CSarahJo%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_editdata.mso"><!--[if !mso]> <style> v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style> <![endif]--><o:smarttagtype namespaceuri="urn:schemas-microsoft-com:eek:ffice:smarttags" name="City"></o:smarttagtype><o:smarttagtype namespaceuri="urn:schemas-microsoft-com:eek:ffice:smarttags" name="place"></o:smarttagtype><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><!--[if !mso]>******** classid="clsid:38481807-CA0E-42D2-BF39-B33AF135CC4D" id=ieooui></object> <style> st1\:*{behavior:url(#ieooui) } </style> <![endif]--><style> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue; text-decoration:underline; text-underline:single;} a:visited, span.MsoHyperlinkFollowed {color:purple; text-decoration:underline; text-underline:single;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} table.MsoTableGrid {mso-style-name:"Table Grid"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; border:solid windowtext 1.0pt; mso-border-alt:solid windowtext .5pt; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-border-insideh:.5pt solid windowtext; mso-border-insidev:.5pt solid windowtext; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> Hi Everyone!

I am new here and need some help. I have Microsoft Excel 2003, not all that experience and have never used Macros. I am designing a database for my uncle and have reached a problem. Currently my data looks like this:

Column A1 is business name and is fine
Column B1, C1 is city and address which are also fine
Columns D1, E1, F1, and G1 is where my problem arises. Each of these columns will need multiple lines of data in them. D1 is contacts (and for some companies I have 10+ contacts) E1 is contact title (need this to line up with D1), F1 is contact email and G1 is contact phone number. I need all of these to line up. Currently I just have them on separate lines, but some do not line up. How can I divide these cells into separate rows (not columns) so they have lines and are easy to read and follow? Any help would be much appreciated!! <o:p></o:p>

Here is an example of what I need. I did this in word; however, I want to do it in excel (that is what my Uncle would like). I already have the company name, city, and state done. I am doing the contacts and rest of the information now. If you think there is a better way to organize this let me know. But here is what I would like to do:

<u1:smarttagtype namespaceuri="urn:schemas-microsoft-com:eek:ffice:smarttags" name="City"></u1:smarttagtype><u1:smarttagtype namespaceuri="urn:schemas-microsoft-com:eek:ffice:smarttags" name="place"></u1:smarttagtype><!--[if gte mso 9]><xml> <u2:WordDocument> <u2:View>Normal</u2:View> <u2:Zoom>0</u2:Zoom> <u2:PunctuationKerning/> <u2:ValidateAgainstSchemas/> <u2:SaveIfXMLInvalid>false</u2:SaveIfXMLInvalid> <u2:IgnoreMixedContent>false</u2:IgnoreMixedContent> <u2:AlwaysShowPlaceholderText>false</u2:AlwaysShowPlaceholderText> <u2:Compatibility> <u2:BreakWrappedTables/> <u2:SnapToGridInCell/> <u2:WrapTextWithPunct/> <u2:UseAsianBreakRules/> <u2:DontGrowAutofit/> </u2:Compatibility> <u2:BrowserLevel>MicrosoftInternetExplorer4</u2:BrowserLevel> </u2:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <u3:LatentStyles DefLockedState="false" LatentStyleCount="156"> </u3:LatentStyles> </xml><![endif]--> <o:p></o:p>
<table class="MsoTableGrid" style="border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0"> <tbody><tr style=""> <td style="border: 1pt solid windowtext; padding: 0in 5.4pt; width: 69.35pt;" valign="top" width="92"> Name<o:p></o:p>
</td> <td style="border-style: solid solid solid none; border-color: -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 87.6pt;" valign="top" width="117"> City<o:p></o:p>
</td> <td style="border-style: solid solid solid none; border-color: -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 34.8pt;" valign="top" width="46"> State<o:p></o:p>
</td> <td style="border-style: solid solid solid none; border-color: -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 73.7pt;" valign="top" width="98"> Contact<o:p></o:p>
</td> <td style="border-style: solid solid solid none; border-color: -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 116.85pt;" valign="top" width="156"> Email<o:p></o:p>
</td> <td style="border-style: solid solid solid none; border-color: -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 60.5pt;" valign="top" width="81"> Phone<o:p></o:p>
</td> </tr> <tr style=""> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 69.35pt;" valign="top" width="92"> Nike<o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 87.6pt;" valign="top" width="117"><st1:city u4:st="on"><st1:place u4:st="on"> <st1:city w:st="on"><st1:place w:st="on">Los Angeles</st1:place></st1:city><o:p></o:p>
</st1:place></st1:city></td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 34.8pt;" valign="top" width="46"> CA<o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 73.7pt;" valign="top" width="98"> Sarah Down<o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 116.85pt;" valign="top" width="156"> Sdown@yahoo.com<o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 60.5pt;" valign="top" width="81"> 555-1234<o:p></o:p>
</td> </tr> <tr style="height: 13.8pt;"> <td rowspan="2" style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 69.35pt; height: 13.8pt;" valign="top" width="92"> Footlocker<o:p></o:p>
</td> <td rowspan="2" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 87.6pt; height: 13.8pt;" valign="top" width="117"><st1:city u4:st="on"><st1:place u4:st="on"> <st1:city w:st="on"><st1:place w:st="on">Los Angeles</st1:place></st1:city><o:p></o:p>
</st1:place></st1:city></td> <td rowspan="2" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 34.8pt; height: 13.8pt;" valign="top" width="46"> CA<o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 73.7pt; height: 13.8pt;" valign="top" width="98"> Billy Bob<o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 116.85pt; height: 13.8pt;" valign="top" width="156"> Bb1@aol.com<o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 60.5pt; height: 13.8pt;" valign="top" width="81"> 444-1234<o:p></o:p>
</td> </tr> <tr style="height: 13.75pt;"> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 73.7pt; height: 13.75pt;" valign="top" width="98"> Katie Smith<o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 116.85pt; height: 13.75pt;" valign="top" width="156"> ks@aol.com<o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 60.5pt; height: 13.75pt;" valign="top" width="81"> 454-6171<o:p></o:p>
</td> </tr> <tr style="height: 4.8pt;"> <td rowspan="6" style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 69.35pt; height: 4.8pt;" valign="top" width="92"> Hilton Hotels<o:p></o:p>
</td> <td rowspan="6" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 87.6pt; height: 4.8pt;" valign="top" width="117"><st1:city u4:st="on"><st1:place u4:st="on"> <st1:city w:st="on"><st1:place w:st="on">Los Angeles</st1:place></st1:city><o:p></o:p>
</st1:place></st1:city></td> <td rowspan="6" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 34.8pt; height: 4.8pt;" valign="top" width="46"> CA<o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 73.7pt; height: 4.8pt;" valign="top" width="98"> Joe Smith<o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 116.85pt; height: 4.8pt;" valign="top" width="156"> jsmith@aol.com<o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 60.5pt; height: 4.8pt;" valign="top" width="81"> 555-1234<o:p></o:p>
</td> </tr> <tr style="height: 4.55pt;"> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 73.7pt; height: 4.55pt;" valign="top" width="98"> Mary Jones<o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 116.85pt; height: 4.55pt;" valign="top" width="156"> jones@aol.com<o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 60.5pt; height: 4.55pt;" valign="top" width="81"> 600-1455<o:p></o:p>
</td> </tr> <tr style="height: 4.55pt;"> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 73.7pt; height: 4.55pt;" valign="top" width="98"> Sarah Murphy<o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 116.85pt; height: 4.55pt;" valign="top" width="156"> smurphy@yahoo.com<o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 60.5pt; height: 4.55pt;" valign="top" width="81"> 800-1234<o:p></o:p>
</td> </tr> <tr style="height: 4.55pt;"> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 73.7pt; height: 4.55pt;" valign="top" width="98"> John Doe<o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 116.85pt; height: 4.55pt;" valign="top" width="156"> jdoe@gmail.com<o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 60.5pt; height: 4.55pt;" valign="top" width="81"> 234-4253<o:p></o:p>
</td> </tr> <tr style="height: 4.55pt;"> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 73.7pt; height: 4.55pt;" valign="top" width="98"> Jane Doe<o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 116.85pt; height: 4.55pt;" valign="top" width="156"> jadoe@gmail.com<o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 60.5pt; height: 4.55pt;" valign="top" width="81"> 235-6898<o:p></o:p>
</td> </tr> <tr style="height: 4.55pt;"> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 73.7pt; height: 4.55pt;" valign="top" width="98"> Bob Hope<o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 116.85pt; height: 4.55pt;" valign="top" width="156"> bhope@yahoo.com<o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 60.5pt; height: 4.55pt;" valign="top" width="81"> 234-5690<o:p></o:p>
</td> </tr> </tbody></table>
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

hiker95

Well-known Member
Joined
Apr 8, 2009
Messages
17,649
SariJo10,

If your data in Excel looks like this:


Excel Workbook
ABCDEF
1NameCityStateContactEmailPhone
2NikeLos AngelesCASarah DownSdown@yahoo.com555-1234
3FootlockerLos AngelesCABilly BobBb1@aol.com444-1234
4Katie Smithks@aol.com454-6171
5Hilton HotelsLos AngelesCAJoe Smithjsmith@aol.com555-1234
6Mary Jonesjones@aol.com600-1455
7Sarah Murphysmurphy@yahoo.com800-1234
8John Doejdoe@gmail.com234-4253
9Jane Doejadoe@gmail.com235-6898
10Bob Hopebhope@yahoo.com234-5690
Sheet1



And you want it to look like this:


Excel Workbook
ABCDEF
1NameCityStateContactEmailPhone
2NikeLos AngelesCASarah DownSdown@yahoo.com555-1234
3FootlockerLos AngelesCABilly BobBb1@aol.com444-1234
4FootlockerLos AngelesCAKatie Smithks@aol.com454-6171
5Hilton HotelsLos AngelesCAJoe Smithjsmith@aol.com555-1234
6Hilton HotelsLos AngelesCAMary Jonesjones@aol.com600-1455
7Hilton HotelsLos AngelesCASarah Murphysmurphy@yahoo.com800-1234
8Hilton HotelsLos AngelesCAJohn Doejdoe@gmail.com234-4253
9Hilton HotelsLos AngelesCAJane Doejadoe@gmail.com235-6898
10Hilton HotelsLos AngelesCABob Hopebhope@yahoo.com234-5690
Sheet1



Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code/or instructions, you never know what you might lose).

Then select columns A, B, and C, and:
Press F5, click Special, tick Blanks, click OK.
Press =
Press Up arrow
Press CTRL + Enter
Select the columns, Edit > Copy, Edit > Paste Special, tick Values, click OK.
 

SariJo10

New Member
Joined
Aug 19, 2009
Messages
10
Thanks for your help. I never thought about doing it the way you have it. Currently, here is an example (I still have lots of data to enter):

I am trying to paste my data but it loses the formatting every time. How can I paste it so you can see it as it looks right now??

<table x:str="" style="border-collapse: collapse; width: 961pt;" width="1280" border="0" cellpadding="0" cellspacing="0"><col style="width: 237pt;" width="316"> <col style="width: 133pt;" width="177"> <col style="width: 48pt;" width="64"> <col style="width: 108pt;" width="144"> <col style="width: 209pt;" width="278"> <col style="width: 127pt;" width="169"> <col style="width: 99pt;" width="132"> <tbody><tr style="height: 25.5pt;" height="34"> <td class="xl26" style="height: 25.5pt; width: 237pt;" x:str="Hilton Hotels Corporation " width="316" height="34">
</td> <td class="xl27" style="width: 133pt;" width="177">
</td> <td class="xl26" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 108pt;" width="144">Ram Avvari
Tim Harvey</td> <td class="xl24" style="width: 209pt;" width="278">PM
CIO</td> <td class="xl25" style="width: 127pt;" width="169">rpavvari@yahoo.com
</td> <td class="xl24" style="width: 99pt;" width="132">(613) 946-1964
(310) 278-4321</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl26" style="height: 12.75pt;" height="17">
</td> <td class="xl27">
</td> <td class="xl26">
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 51pt;" height="68"> <td class="xl26" style="height: 51pt;" height="68">
</td> <td class="xl27">
</td> <td class="xl26">
</td> <td class="xl28" style="width: 108pt;" width="144">Anne Kuhns
Dennis Whitlow</td> <td class="xl28" style="width: 209pt;" width="278">Manager, Information Technology Security
Director, Global Data Center Consolidation</td> <td class="xl29">dennis.whitlow@disney.com</td> <td class="xl26">(407) 824-2222</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl26" style="height: 12.75pt;" x:str="The Ryland Group, Inc. " height="17">
</td> <td class="xl27">
</td> <td class="xl26">
</td> <td class="xl26">Jon Bartlett</td> <td class="xl26">Senior Network Security Engineer</td> <td>
</td> <td class="xl26">(818) 223-7500</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl26" style="height: 12.75pt;" x:str="CKE Restaurants, Inc. " height="17">
</td> <td class="xl27">
</td> <td class="xl26">
</td> <td class="xl26">Daniel Baker</td> <td class="xl26">Director of IT Security</td> <td>
</td> <td class="xl26">(714) 778-7198</td> </tr> </tbody></table>
 

SariJo10

New Member
Joined
Aug 19, 2009
Messages
10
West Region

<table style="background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt; font-family: Arial,Arial; font-size: 10pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup> <col style="width: 30px; font-weight: bold;"> <col style="width: 316px;"> <col style="width: 177px;"> <col style="width: 64px;"> <col style="width: 144px;"> <col style="width: 278px;"> <col style="width: 169px;"> <col style="width: 132px;"></colgroup> <tbody> <tr style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt; font-weight: bold;"> <td>
</td> <td>A</td> <td>B</td> <td>C</td> <td>D</td> <td>E</td> <td>F</td> <td>G</td></tr> <tr style="height: 34px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">2</td> <td>Hilton Hotels Corporation </td> <td>Beverly Hills</td> <td>CA</td> <td>Ram Avvari
Tim Harvey</td> <td>PM
CIO</td> <td style="color: rgb(0, 0, 255); text-decoration: underline;">rpavvari@yahoo.com
</td> <td>(613) 946-1964
(310) 278-4321</td></tr> <tr style="height: 17px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">3</td> <td>Live Nation, Inc.</td> <td>Beverly Hills</td> <td>CA</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td></tr> <tr style="height: 34px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">4</td> <td>The Walt Disney Company</td> <td>Burbank</td> <td>CA</td> <td>Anne Kuhns
Dennis Whitlow</td> <td>Manager, Information Technology Security
Director, Global Data Center Consolidation</td> <td style="color: rgb(0, 0, 255); text-decoration: underline;">dennis.whitlow@disney.com</td> <td>(407) 824-2222
(818) 560-6668</td></tr> <tr style="height: 17px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">5</td> <td>The Ryland Group, Inc. </td> <td>Calabasas</td> <td>CA</td> <td>Jon Bartlett</td> <td>Senior Network Security Engineer</td> <td>
</td> <td>(818) 223-7500</td></tr> <tr style="height: 17px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">6</td> <td>CKE Restaurants, Inc. </td> <td>Carpinteria</td> <td>CA</td> <td>Daniel Baker</td> <td>Director of IT Security</td> <td>
</td> <td>(714) 778-7198</td></tr> <tr style="height: 17px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">7</td> <td>Jacuzzi Brands Corporation</td> <td>Chino Hills</td> <td>CA</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td></tr></tbody></table>

Excel tables to the web >> Excel Jeanie HTML 4
 

SariJo10

New Member
Joined
Aug 19, 2009
Messages
10

ADVERTISEMENT

Thank you Hiker so much for your help! That is what it currently looks like. I have about 15 contacts for Walt Disney alone, and I have just been using Alt+ Enter to put them on separate lines. The problem is, when I am done they don't line up. What do you suggest?
 

SariJo10

New Member
Joined
Aug 19, 2009
Messages
10
Also, I should've probably said that what I wanted to do was keep it all in one cell, and just create rows within the cell. If I have to, I can do it the way you showed me, it will just end up being longer in length.
 

hiker95

Well-known Member
Joined
Apr 8, 2009
Messages
17,649
SariJo10,

I just pasted your posted data, and ran a macro that I have, and here is what I got:


Excel Workbook
ABCDEFG
2Hilton Hotels CorporationBeverly HillsCARam AvvariPMrpavvari@yahoo.com(613) 946-1964
3Tim HarveyCIO(310) 278-4321
4Live Nation, Inc.Beverly HillsCA
5The Walt Disney CompanyBurbankCAAnne KuhnsManager, Information Technology Securitydennis.whitlow@disney.com(407) 824-2222
6Dennis WhitlowDirector, Global Data Center Consolidation(818) 560-6668
7The Ryland Group, Inc.CalabasasCAJon BartlettSenior Network Security Engineer(818) 223-7500
8CKE Restaurants, Inc.CarpinteriaCADaniel BakerDirector of IT Security(714) 778-7198
9Jacuzzi Brands CorporationChino HillsCA
West Region



I have been involed with database management for a long time, and your screenshot does not make sense to me, especially if you were searching for one person's name.


This makes more sense to me (my personal preference):


Excel Workbook
ABCDEFG
2Hilton Hotels CorporationBeverly HillsCARam AvvariPMrpavvari@yahoo.com(613) 946-1964
3Hilton Hotels CorporationBeverly HillsCATim HarveyCIO(310) 278-4321
4Live Nation, Inc.Beverly HillsCA
5The Walt Disney CompanyBurbankCAAnne KuhnsManager, Information Technology Securitydennis.whitlow@disney.com(407) 824-2222
6The Walt Disney CompanyBurbankCADennis WhitlowDirector, Global Data Center Consolidation(818) 560-6668
7The Ryland Group, Inc.CalabasasCAJon BartlettSenior Network Security Engineer(818) 223-7500
8CKE Restaurants, Inc.CarpinteriaCADaniel BakerDirector of IT Security(714) 778-7198
9Jacuzzi Brands CorporationChino HillsCA
West Region
 

SariJo10

New Member
Joined
Aug 19, 2009
Messages
10
Thank you so much for all of your help. I never thought of just inserting them in a separate row. This has been bothering me all day. You have no idea how much I appreciate it. If there is anything I can ever help you with (hahaha I doubt it) let me know.

Have a great night!

Sarah :)
SariJo10@aol.com
 

Watch MrExcel Video

Forum statistics

Threads
1,122,708
Messages
5,597,688
Members
414,164
Latest member
ARTW

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top