OK
Step 4 a
Replace "Team_" with "" (null string)
- Code: Select all
Team</td><td>P</td><td>W</td><td>D</td><td>L</td><td>F</td><td>A</td><td>Pts</td></tr><tr>
1_FC</td><td>12</td><td>10</td><td>1</td><td>1</td><td>55</td><td>12</td><td>31</td></tr><tr>
2_FC</td><td>10</td><td>9</td><td>1</td><td>0</td><td>43</td><td>7</td><td>28</td></tr><tr>
United_FC</td><td>11</td><td>7</td><td>1</td><td>3</td><td>46</td><td>12</td><td>22</td></tr><tr>
RANGERS_FC</td><td>14</td><td>5</td><td>5</td><td>4</td><td>33</td><td>24</td><td>20</td></tr><tr>
City</td><td>13</td><td>5</td><td>2</td><td>6</td><td>35</td><td>36</td><td>17</td></tr><tr>
TOWN_COLTS</td><td>12</td><td>4</td><td>3</td><td>5</td><td>34</td><td>20</td><td>15</td></tr><tr>
FC</td><td>14</td><td>4</td><td>2</td><td>8</td><td>25</td><td>48</td><td>14</td></tr><tr>
COLTS.</td><td>15</td><td>3</td><td>2</td><td>10</td><td>18</td><td>67</td><td>11</td></tr><tr>
WEL_TIGERS.</td><td>13</td><td>1</td><td>1</td><td>11</td><td>11</td><td>74</td><td>4</td></tr><tr>
Then continue with Step 5 etc...
and 4 should read: With the REPLACE TEXT function replace "^P" (line feed/end of line) with "</td></tr><tr>^P"
<td>
Final result after formating:
- Code: Select all
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="content-type">
<title></title>
</head>
<body>
<table style="text-align: left; width: 75%;" border="1"
cellpadding="2" cellspacing="2">
<tbody>
<tr>
<td>Team</td>
<td>P</td>
<td>W</td>
<td>D</td>
<td>L</td>
<td>F</td>
<td>A</td>
<td>Pts</td>
</tr>
<tr>
<td> 1 FC</td>
<td>12</td>
<td>10</td>
<td>1</td>
<td>1</td>
<td>55</td>
<td>12</td>
<td>31</td>
</tr>
<tr>
<td> 2 FC</td>
<td>10</td>
<td>9</td>
<td>1</td>
<td>0</td>
<td>43</td>
<td>7</td>
<td>28</td>
</tr>
<tr>
<td> United FC</td>
<td>11</td>
<td>7</td>
<td>1</td>
<td>3</td>
<td>46</td>
<td>12</td>
<td>22</td>
</tr>
<tr>
<td> RANGERS FC</td>
<td>14</td>
<td>5</td>
<td>5</td>
<td>4</td>
<td>33</td>
<td>24</td>
<td>20</td>
</tr>
<tr>
<td> City</td>
<td>13</td>
<td>5</td>
<td>2</td>
<td>6</td>
<td>35</td>
<td>36</td>
<td>17</td>
</tr>
<tr>
<td> TOWN COLTS</td>
<td>12</td>
<td>4</td>
<td>3</td>
<td>5</td>
<td>34</td>
<td>20</td>
<td>15</td>
</tr>
<tr>
<td> FC</td>
<td>14</td>
<td>4</td>
<td>2</td>
<td>8</td>
<td>25</td>
<td>48</td>
<td>14</td>
</tr>
<tr>
<td> COLTS.</td>
<td>15</td>
<td>3</td>
<td>2</td>
<td>10</td>
<td>18</td>
<td>67</td>
<td>11</td>
</tr>
<tr>
<td> WEL TIGERS.</td>
<td>13</td>
<td>1</td>
<td>1</td>
<td>11</td>
<td>11</td>
<td>74</td>
<td>4</td>
</tr>
</tbody>
</table>
<html>