Re: Serienetikettendruck
"Norbert R. Obst" <[email protected]> Fri, 2 Jan 2015 17:47:30 +0100
| Newsgroups | gmane.os.apple.ragtime.german |
|---|---|
| Message-ID | <[email protected]> |
--Apple-Mail=_EF48AE8A-FA5D-4BD5-A7AC-07FC1904658A Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=windows-1252 Hallo Thomas, welch=92 bisher von mir unentdeckte Funktion =84Gl=E4tten=93. RagTime = und Du haben immer wieder zumindest f=FCr mich =84altem Hasen=93 = =DCberraschungen bereit. Danke f=FCr den Hinweis und nur weiter so im = Jahre 2015, zu dem ich Dir und aller =84Mitlesern=93 Gesundheit und = Zufriedensein in aller Freude w=FCnsche. Mit freundlichen Gr=FC=DFen Norbert O Am 02.01.2015 um 08:16 schrieb Thomas Kaegi <[email protected]>: > Hallo Klaus >=20 > Hast du die Funktion "Gl=E4tten" bemerkt, die dein Problem l=F6st? = Erg=E4nze deine Formel so: >=20 > = Gl=E4tten(Index(kunden!$B:$B;Spalte+Z=E4hler))&&Gl=E4tten(Index(kunden!$C:= $C;Spalte+Z=E4hler))&&Gl=E4tten(Index(kunden!$D:$D;Spalte+Z=E4hler)) >=20 > Damit werden die =FCberfl=FCssigen Leerzeichen entfernt. >=20 > Freundlicher Gruss, Thomas >=20 --Apple-Mail=_EF48AE8A-FA5D-4BD5-A7AC-07FC1904658A Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=windows-1252 <html><head><meta http-equiv=3D"Content-Type" content=3D"text/html = charset=3Dwindows-1252"></head><body style=3D"word-wrap: break-word; = -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><span = style=3D"font-family: Helvetica; orphans: 2; widows: 2;">Hallo = Thomas,</span><br><div apple-content-edited=3D"true"><span = class=3D"Apple-style-span" style=3D"border-collapse: separate; = font-family: Helvetica; border-spacing: 0px;"><span = class=3D"Apple-style-span" style=3D"border-collapse: separate; color: = rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: = normal; font-weight: normal; letter-spacing: normal; line-height: = normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: = normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: = 0px; -webkit-border-vertical-spacing: 0px; = -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: = auto; -webkit-text-stroke-width: 0px; "><div style=3D"word-wrap: = break-word; -webkit-nbsp-mode: space; -webkit-line-break: = after-white-space; "><span class=3D"Apple-style-span" = style=3D"border-collapse: separate; color: rgb(0, 0, 0); font-family: = Helvetica; font-size: 12px; font-style: normal; font-variant: normal; = font-weight: normal; letter-spacing: normal; line-height: normal; = orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; = widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; = -webkit-border-vertical-spacing: 0px; = -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: = auto; -webkit-text-stroke-width: 0px; "><div style=3D"word-wrap: = break-word; -webkit-nbsp-mode: space; -webkit-line-break: = after-white-space; "><span class=3D"Apple-style-span" = style=3D"border-collapse: separate; color: rgb(0, 0, 0); font-family: = Helvetica; font-size: 12px; font-style: normal; font-variant: normal; = font-weight: normal; letter-spacing: normal; line-height: normal; = orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; = widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; = -webkit-border-vertical-spacing: 0px; = -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: = auto; -webkit-text-stroke-width: 0px; "><div style=3D"word-wrap: = break-word; -webkit-nbsp-mode: space; -webkit-line-break: = after-white-space; "><span class=3D"Apple-style-span" = style=3D"border-collapse: separate; color: rgb(0, 0, 0); font-family: = Helvetica; font-size: 12px; font-style: normal; font-variant: normal; = font-weight: normal; letter-spacing: normal; line-height: normal; = orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; = widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; = -webkit-border-vertical-spacing: 0px; = -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: = auto; -webkit-text-stroke-width: 0px; "><div style=3D"word-wrap: = break-word; -webkit-nbsp-mode: space; -webkit-line-break: = after-white-space; "><span class=3D"Apple-style-span" = style=3D"border-collapse: separate; color: rgb(0, 0, 0); font-family: = Helvetica; font-size: 12px; font-style: normal; font-variant: normal; = font-weight: normal; letter-spacing: normal; line-height: normal; = orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; = widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; = -webkit-border-vertical-spacing: 0px; = -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: = auto; -webkit-text-stroke-width: 0px; "><div style=3D"word-wrap: = break-word; -webkit-nbsp-mode: space; -webkit-line-break: = after-white-space; "><span class=3D"Apple-style-span" = style=3D"border-collapse: separate; color: rgb(0, 0, 0); font-family: = Helvetica; font-size: 12px; font-style: normal; font-variant: normal; = font-weight: normal; letter-spacing: normal; line-height: normal; = orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; = widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; = -webkit-border-vertical-spacing: 0px; = -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: = auto; -webkit-text-stroke-width: 0px; "><div style=3D"word-wrap: = break-word; -webkit-nbsp-mode: space; -webkit-line-break: = after-white-space; "><span class=3D"Apple-style-span" = style=3D"border-collapse: separate; color: rgb(0, 0, 0); font-family: = Helvetica; font-size: 12px; font-style: normal; font-variant: normal; = font-weight: normal; letter-spacing: normal; line-height: normal; = orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; = widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; = -webkit-border-vertical-spacing: 0px; = -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: = auto; -webkit-text-stroke-width: 0px; "><div style=3D"word-wrap: = break-word; -webkit-nbsp-mode: space; -webkit-line-break: = after-white-space; "><span class=3D"Apple-style-span" = style=3D"border-collapse: separate; color: rgb(0, 0, 0); font-family: = Helvetica; font-size: 12px; font-style: normal; font-variant: normal; = font-weight: normal; letter-spacing: normal; line-height: normal; = orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; = widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; = -webkit-border-vertical-spacing: 0px; = -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: = auto; -webkit-text-stroke-width: 0px; "><div style=3D"word-wrap: = break-word; -webkit-nbsp-mode: space; -webkit-line-break: = after-white-space; "><span class=3D"Apple-style-span" = style=3D"border-collapse: separate; color: rgb(0, 0, 0); font-family: = Helvetica; font-size: 12px; font-style: normal; font-variant: normal; = font-weight: normal; letter-spacing: normal; line-height: normal; = orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; = widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; = -webkit-border-vertical-spacing: 0px; = -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: = auto; -webkit-text-stroke-width: 0px; "><div style=3D"word-wrap: = break-word; -webkit-nbsp-mode: space; -webkit-line-break: = after-white-space; "><span class=3D"Apple-style-span" = style=3D"border-collapse: separate; color: rgb(0, 0, 0); font-family: = Helvetica; font-size: 12px; font-style: normal; font-variant: normal; = font-weight: normal; letter-spacing: normal; line-height: normal; = orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; = widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; = -webkit-border-vertical-spacing: 0px; = -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: = auto; -webkit-text-stroke-width: 0px; "><div style=3D"word-wrap: = break-word; -webkit-nbsp-mode: space; -webkit-line-break: = after-white-space; "><div><div><div><div><div><br></div><div>welch=92 = bisher von mir unentdeckte Funktion =84Gl=E4tten=93. RagTime und Du = haben immer wieder zumindest f=FCr mich =84altem Hasen=93 =DCberraschungen= bereit. Danke f=FCr den Hinweis und nur weiter so im Jahre 2015, zu dem = ich Dir und aller =84Mitlesern=93 Gesundheit und Zufriedensein in aller = Freude w=FCnsche.</div><div><br></div><div>Mit freundlichen = Gr=FC=DFen</div><div>Norbert = O</div><div><br></div><br></div><br></div><br></div><br></div><br></div></= span><br class=3D"Apple-interchange-newline"></div></span><br = class=3D"Apple-interchange-newline"></div></span><br = class=3D"Apple-interchange-newline"></div></span><br = class=3D"Apple-interchange-newline"></div></span><br = class=3D"Apple-interchange-newline"></div></span><br = class=3D"Apple-interchange-newline"></div></span><br = class=3D"Apple-interchange-newline"></div></span><br = class=3D"Apple-interchange-newline"></div></span><br = class=3D"Apple-interchange-newline"></div></span><br = class=3D"Apple-interchange-newline"></span><br = class=3D"Apple-interchange-newline"> </div> <br><div><div>Am 02.01.2015 um 08:16 schrieb Thomas Kaegi <<a = href=3D"mailto:[email protected]">[email protected]</a>>:</div><br = class=3D"Apple-interchange-newline"><blockquote = type=3D"cite"><div><p>Hallo Klaus</p><p>Hast du die Funktion "Gl=E4tten" = bemerkt, die dein Problem l=F6st? Erg=E4nze deine Formel = so:</p><p><code>Gl=E4tten(Index(kunden!$B:$B;Spalte+Z=E4hler))&&Gl= =E4tten(Index(kunden!$C:$C;Spalte+Z=E4hler))&&Gl=E4tten(Index(kund= en!$D:$D;Spalte+Z=E4hler))</code></p><p>Damit werden die =FCberfl=FCssigen= Leerzeichen entfernt.</p><p>Freundlicher Gruss, Thomas</p> </div></blockquote></div><br></body></html>= --Apple-Mail=_EF48AE8A-FA5D-4BD5-A7AC-07FC1904658A--