Wie weet de list?
=TRIM(RIGHT(SUBSTITUTE(text," ",REPT(" ",100)),100))
Met name het deel met REPT zegt mij nog niets
Je dient eea nog in het Nederlands om te zetten.REPT is HERHALINGhttps://support.microsoft.com/nl-nl/office/herhaling-functie-04c4d778-e712-43b4-9c15-d656582bb061SUBSTITUTE is SUBSTITUERENhttps://support.microsoft.com/nl-nl/office/substitueren-functie-6434944e-a904-4336-a9b0-1e58df3bc332TRIM is SPATIES.WISSENhttps://support.microsoft.com/nl-nl/office/spaties-wissen-functie-410388fa-c5df-49c6-b16c-9e5630b479f9RIGHT is RECHTShttps://support.microsoft.com/nl-nl/office/rechts-rechtsb-functie-240267ee-9afa-4639-a02b-f19e1786cf2f
=SPATIES.WISSEN(RECHTS(SUBSTITUEREN(text," ",HERHALING(" ",100)),100))blijft hardnekkig een foutmelding geven.
Als de hele formule in het Nederlands staat moet "text" dan niet "tekst" zijn?
=SPATIES.WISSEN(RECHTS(SUBSTITUEREN(text," ",HERHALING(" ",100)),100))
Functions Translator helps people use a localized version of Excel by helping translate from the US Excel function names, or research how to create a solution on the web with predominately English content.Easily find the equivalent localized functions and formulas in any of the supported 15 languages. Functions Translator will automatically configure the language settings to US and the Localized version, and people can provide feedback on the translation of functions if it is not what they expected.The solution support Excel Online, Excel 2013 and Excel 2016 for Desktop, and the latest version of Excel for Mac and iPad.