Split numbers and text in same column

X

xandertio

New Member
Joined
Nov 25, 2009
Messages
25
Hi all,

I am new to the mr. excel forum. So I hope I am asking the wright things within the good thread...

I have got a question regarding splitting numbers from text that are in the same column. Is there a quick solution to my problem.
Text to columns won't work because the data is not the same.

See below the an example of my data:

<table style="border-collapse: collapse; width: 169pt;" width="225" border="0" cellpadding="0" cellspacing="0"><col style="width: 169pt;" width="225"> <tbody><tr style="height: 11.25pt;" height="15"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 1.5pt; background: rgb(79, 129, 189) none repeat scroll 0% 0%; height: 11.25pt; width: 169pt; font-size: 8pt; color: white; font-weight: 700; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="225" height="15">Address</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 11.25pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="15">Wilhelminastraat 78</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 11.25pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="15">Kampstraat 45</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 11.25pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="15">Kohlbergsgracht 1</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 11.25pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="15">Jos Klijnenlaan 23</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 11.25pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="15">Beekstraat 4</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 11.25pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="15">Akerstraat Noord 74</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 11.25pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="15">Veeladingstraat 14</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 11.25pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="15">Becamusstraat 15</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 11.25pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="15">Wilhelminalaan 1</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 11.25pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="15">Wijngracht 51</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 11.25pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="15">Raadhuisstraat 21</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 11.25pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="15">Henri Weltersstraat 70b</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 11.25pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="15">Stationsweg 60 A</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 11.25pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="15">Proost de Beaufortstraat 1</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 11.25pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="15">Ovidiusstraat 117</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 11.25pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="15">Ganzeweide 71</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 11.25pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="15">Kerkstraat 46</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 11.25pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="15">Kampstraat 45</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 11.25pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="15">Wilhelminasingel 237</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 11.25pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="15">Pater van den Elsenplein 90</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 11.25pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="15">A Ge Water 20</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 11.25pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="15">Zeswegenlaan 183</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 11.25pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="15">Dorien Verschureplein 10b</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 11.25pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="15">Oude raadhuis 10</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 11.25pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="15">Kruisstraat 39</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 11.25pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="15">Van Lennepstraat 4</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 11.25pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="15">Burgemeester Waszinkstraat 2</td> </tr> </tbody></table>
What I am loooking for is:

<table style="border-collapse: collapse; width: 129pt;" width="172" border="0" cellpadding="0" cellspacing="0"><col style="width: 81pt;" width="108"> <col style="width: 48pt;" width="64"> <tbody><tr style="height: 11.25pt;" height="15"> <td class="xl65" style="height: 11.25pt; width: 81pt;" width="108" height="15">Adress</td> <td class="xl65" style="width: 48pt;" width="64">Number</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">Wilhelminastraat </td> <td class="xl65" align="right">78</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="border-top: medium none; height: 11.25pt;" height="15">Kampstraat</td> <td class="xl65" align="right">45</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="border-top: medium none; height: 11.25pt;" height="15">Kohlbergsgracht</td> <td class="xl65" align="right">1</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="border-top: medium none; height: 11.25pt;" height="15">Jos Klijnenlaan </td> <td class="xl65" align="right">23</td> </tr> </tbody></table>
Thank you in advance!
Xander
 
Last edited:

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
Sort by date Sort by votes
Here's a name based solution.

Select a cell in row 1 and define these names

Name: textPart
RefersTo: =TRIM(LEFT(Sheet1!$A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},Sheet1!$A1&"1234567890"))-1))

Name: numberPart
RefersTo: =SUBSTITUTE(Sheet1!$A1,textPart,"")

Name: numberPartValue
RefersTo: =MAX(IF(ISNUMBER(LEFT(numberPart,{1,2,3,4,5})+0),LEFT(numberPart,{1,2,3,4,5})+0,0))

Enter =textpart in a cell and drag down.
Enter =numberPartValue as a CSE formula and drag down.

CSE formulas should be entered with Ctrl-Shift-Enter (Cmd+Return for Mac)
 
Upvote 0
My guess:

Excel Workbook
ABC
1Address
2Wilhelminastraat 78Wilhelminastraat78
3Kampstraat 45Kampstraat45
4Kohlbergsgracht 1Kohlbergsgracht1
5Jos Klijnenlaan 23Jos Klijnenlaan23
6Beekstraat 4Beekstraat4
7Akerstraat Noord 74Akerstraat Noord74
8Veeladingstraat 14Veeladingstraat14
9Becamusstraat 15Becamusstraat15
10Wilhelminalaan 1Wilhelminalaan1
11Wijngracht 51Wijngracht51
12Raadhuisstraat 21Raadhuisstraat21
13Henri Weltersstraat 70bHenri Weltersstraat70b
14Stationsweg 60 AStationsweg60 A
15Proost de Beaufortstraat 1Proost de Beaufortstraat1
Separate Text
 
Upvote 0
Thank you all for the help!!
Below the result in my spreadsheet.

<table style="border-collapse: collapse; width: 519pt;" width="692" border="0" cellpadding="0" cellspacing="0"><col style="width: 169pt;" width="225"> <col style="width: 302pt;" width="403"> <col style="width: 48pt;" width="64"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 1.5pt; background: rgb(79, 129, 189) none repeat scroll 0% 0%; height: 12.75pt; width: 169pt; font-size: 8pt; color: white; font-weight: 700; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="225" height="17">Address</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 1.5pt medium; background: rgb(79, 129, 189) none repeat scroll 0% 0%; width: 302pt; font-size: 10pt; color: white; font-weight: 700; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="403">Column1</td> <td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color white; border-width: medium medium 1.5pt; background: rgb(79, 129, 189) none repeat scroll 0% 0%; width: 48pt; font-size: 10pt; color: white; font-weight: 700; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="64">Column2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Wilhelminastraat 78</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LEFT(D2,MIN(FIND(0,SUBSTITUTE(D2,{1,2,3,4,5,6,7,8,9},0)&0))-1)</td> <td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color white; border-width: medium medium 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Kampstraat 45</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LEFT(D2,MIN(FIND(0,SUBSTITUTE(D2,{1,2,3,4,5,6,7,8,9},0)&0))-1)</td> <td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color white; border-width: medium medium 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Kohlbergsgracht 1</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LEFT(D2,MIN(FIND(0,SUBSTITUTE(D2,{1,2,3,4,5,6,7,8,9},0)&0))-1)</td> <td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color white; border-width: medium medium 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Jos Klijnenlaan 23</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LEFT(D2,MIN(FIND(0,SUBSTITUTE(D2,{1,2,3,4,5,6,7,8,9},0)&0))-1)</td> <td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color white; border-width: medium medium 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Beekstraat 4</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LEFT(D2,MIN(FIND(0,SUBSTITUTE(D2,{1,2,3,4,5,6,7,8,9},0)&0))-1)</td> <td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color white; border-width: medium medium 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Akerstraat Noord 74</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LEFT(D2,MIN(FIND(0,SUBSTITUTE(D2,{1,2,3,4,5,6,7,8,9},0)&0))-1)</td> <td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color white; border-width: medium medium 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Veeladingstraat 14</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LEFT(D2,MIN(FIND(0,SUBSTITUTE(D2,{1,2,3,4,5,6,7,8,9},0)&0))-1)</td> <td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color white; border-width: medium medium 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Becamusstraat 15</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LEFT(D2,MIN(FIND(0,SUBSTITUTE(D2,{1,2,3,4,5,6,7,8,9},0)&0))-1)</td> <td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color white; border-width: medium medium 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Wilhelminalaan 1</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LEFT(D2,MIN(FIND(0,SUBSTITUTE(D2,{1,2,3,4,5,6,7,8,9},0)&0))-1)</td> <td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color white; border-width: medium medium 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Wijngracht 51</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">LEFT(D2,MIN(FIND(0,SUBSTITUTE(D2,{1,2,3,4,5,6,7,8,9},0)&0))-1)</td> <td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color white; border-width: medium medium 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> </tr> </tbody></table>
What am I doing wrong?
Xander
 
Upvote 0
hereby te result when copying the whole formula

<table style="border-collapse: collapse; width: 568pt;" width="757" border="0" cellpadding="0" cellspacing="0"><col style="width: 169pt;" width="225"> <col style="width: 399pt;" width="532"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border: 0.5pt solid white; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 12.75pt; width: 169pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="225" height="17">Wilhelminastraat 78</td> <td style="border-style: solid solid solid none; border-color: white white white -moz-use-text-color; border-width: 0.5pt 0.5pt 0.5pt medium; background: rgb(184, 204, 228) none repeat scroll 0% 0%; width: 399pt; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="532">=TRIM(LEFT(Sheet1!$A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},Sheet1!$A1&"1234567890"))-1))</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Kampstraat 45</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">=TRIM(LEFT(Sheet1!$A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},Sheet1!$A1&"1234567890"))-1))</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Kohlbergsgracht 1</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">=TRIM(LEFT(Sheet1!$A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},Sheet1!$A1&"1234567890"))-1))</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Jos Klijnenlaan 23</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">=TRIM(LEFT(Sheet1!$A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},Sheet1!$A1&"1234567890"))-1))</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Beekstraat 4</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">=TRIM(LEFT(Sheet1!$A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},Sheet1!$A1&"1234567890"))-1))</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Akerstraat Noord 74</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">=TRIM(LEFT(Sheet1!$A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},Sheet1!$A1&"1234567890"))-1))</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Veeladingstraat 14</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">=TRIM(LEFT(Sheet1!$A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},Sheet1!$A1&"1234567890"))-1))</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Becamusstraat 15</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">=TRIM(LEFT(Sheet1!$A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},Sheet1!$A1&"1234567890"))-1))</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Wilhelminalaan 1</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">=TRIM(LEFT(Sheet1!$A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},Sheet1!$A1&"1234567890"))-1))</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Wijngracht 51</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">=TRIM(LEFT(Sheet1!$A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},Sheet1!$A1&"1234567890"))-1))</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Raadhuisstraat 21</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">=TRIM(LEFT(Sheet1!$A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},Sheet1!$A1&"1234567890"))-1))</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Henri Weltersstraat 70b</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">=TRIM(LEFT(Sheet1!$A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},Sheet1!$A1&"1234567890"))-1))</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Stationsweg 60 A</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">=TRIM(LEFT(Sheet1!$A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},Sheet1!$A1&"1234567890"))-1))</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Proost de Beaufortstraat 1</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">=TRIM(LEFT(Sheet1!$A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},Sheet1!$A1&"1234567890"))-1))</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Ovidiusstraat 117</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">=TRIM(LEFT(Sheet1!$A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},Sheet1!$A1&"1234567890"))-1))</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Ganzeweide 71</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">=TRIM(LEFT(Sheet1!$A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},Sheet1!$A1&"1234567890"))-1))</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Kerkstraat 46</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">=TRIM(LEFT(Sheet1!$A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},Sheet1!$A1&"1234567890"))-1))</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Kampstraat 45</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">=TRIM(LEFT(Sheet1!$A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},Sheet1!$A1&"1234567890"))-1))</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Wilhelminasingel 237</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">=TRIM(LEFT(Sheet1!$A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},Sheet1!$A1&"1234567890"))-1))</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Pater van den Elsenplein 90</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">=TRIM(LEFT(Sheet1!$A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},Sheet1!$A1&"1234567890"))-1))</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">A Ge Water 20</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">=TRIM(LEFT(Sheet1!$A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},Sheet1!$A1&"1234567890"))-1))</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Zeswegenlaan 183</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">=TRIM(LEFT(Sheet1!$A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},Sheet1!$A1&"1234567890"))-1))</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Dorien Verschureplein 10b</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">=TRIM(LEFT(Sheet1!$A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},Sheet1!$A1&"1234567890"))-1))</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Oude raadhuis 10</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">=TRIM(LEFT(Sheet1!$A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},Sheet1!$A1&"1234567890"))-1))</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Kruisstraat 39</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">=TRIM(LEFT(Sheet1!$A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},Sheet1!$A1&"1234567890"))-1))</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Van Lennepstraat 4</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">=TRIM(LEFT(Sheet1!$A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},Sheet1!$A1&"1234567890"))-1))</td> </tr> </tbody></table>
 
Upvote 0
Are you set up to view formulas instead of results ?
Try
Tools
Options
View
Under Window Options, make sure the Formulas box does NOT have a tick.

If it already does not have a tick, then I guess it's a problem with pasting in from the thread.
Try just editing one of the formulas, perhaps deleting a single character and then replacing it, and hitting enter. If that works, copy the formula down.
 
Upvote 0
Hi All,

I think I found the solution. I am working with a English version of excel. I replaced the "," by a ";" and that works...

thnx
 
Upvote 0
Sorry guys,

One last question! Now I have got the result below
<table style="border-collapse: collapse; width: 768pt;" width="1023" border="0" cellpadding="0" cellspacing="0"><col style="width: 169pt;" width="225"> <col style="width: 399pt;" width="532"> <col style="width: 100pt;" span="2" width="133"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 1.5pt; background: rgb(79, 129, 189) none repeat scroll 0% 0%; height: 12.75pt; width: 169pt; font-size: 8pt; color: white; font-weight: 700; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="225" height="17">Address</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 1.5pt medium; background: rgb(79, 129, 189) none repeat scroll 0% 0%; width: 399pt; font-size: 10pt; color: white; font-weight: 700; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="532">Adres</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 1.5pt medium; background: rgb(79, 129, 189) none repeat scroll 0% 0%; width: 100pt; font-size: 10pt; color: white; font-weight: 700; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="133">Huisnummer</td> <td class="xl67" style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color white; border-width: medium medium 1.5pt; background: rgb(79, 129, 189) none repeat scroll 0% 0%; width: 100pt; font-size: 8pt; color: white; font-weight: 700; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="133">Toevoeging</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Wilhelminastraat 78</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Wilhelminastraat</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">78</td> <td class="xl66" style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color white; border-width: medium medium 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Kampstraat 45</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Kampstraat</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">45</td> <td class="xl66" style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color white; border-width: medium medium 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Kohlbergsgracht 1</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Kohlbergsgracht</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">1</td> <td class="xl66" style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color white; border-width: medium medium 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Jos Klijnenlaan 23</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Jos Klijnenlaan</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">23</td> <td class="xl66" style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color white; border-width: medium medium 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Beekstraat 4</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Beekstraat</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">4</td> <td class="xl66" style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color white; border-width: medium medium 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Akerstraat Noord 74</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Akerstraat Noord</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">74</td> <td class="xl66" style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color white; border-width: medium medium 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Veeladingstraat 14</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Veeladingstraat</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">14</td> <td class="xl66" style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color white; border-width: medium medium 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Becamusstraat 15</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Becamusstraat</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">15</td> <td class="xl66" style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color white; border-width: medium medium 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Wilhelminalaan 1</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Wilhelminalaan</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">1</td> <td class="xl66" style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color white; border-width: medium medium 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Wijngracht 51</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Wijngracht</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">51</td> <td class="xl66" style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color white; border-width: medium medium 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Raadhuisstraat 21</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Raadhuisstraat</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">21</td> <td class="xl66" style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color white; border-width: medium medium 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Henri Weltersstraat 70b</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Henri Weltersstraat</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">70b</td> <td class="xl66" style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color white; border-width: medium medium 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0% 0%; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="border-style: none solid solid; border-color: -moz-use-text-color white white; border-width: medium 0.5pt 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; height: 12.75pt; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="17">Stationsweg 60 A</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Stationsweg</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color white white -moz-use-text-color; border-width: medium 0.5pt 0.5pt medium; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">60 A</td> <td class="xl66" style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color white; border-width: medium medium 0.5pt; background: rgb(184, 204, 228) none repeat scroll 0% 0%; font-size: 8pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> </tr> </tbody></table>
But in Holland we are using letters in our housenumber. The file I am building will be used for importing in an other program. This program wants housenumber and letters in housenumbers seperate.

Please let me know how I can split numbers in the column 'Huisnummer' from letters in the same column

Thanks again.
Xander
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
816
gvsumich
G
E
  • Question
Adding a custom message.
Replies
1
Views
421
Micron
M
A
  • Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
1K
Attrazion
A
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
1K
CrashOD
C
A
  • Solved
Calendar form cancel button passing data to worksheet
Replies
7
Views
380
AndyEd
A

Forum statistics

Threads
1,214,588
Messages
6,120,412
Members
448,959
Latest member
camelliaCase

Share this page

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
Back
Top