When concatenating concatenates don't concatenate...

D

d'Az

Hello Dave,

Thanks for your reply:

I'm using (a French version of) Windows XP Professional 5.1, with Exce
2003 for students and teachers.

The following formula in cell I1
=[Concats.xls]Final!B3

derived from the formul
=CONCATENATE(B5;B6;B7;B8;B9;B10;B11;B12;B13;B14;B15;B16;B17) i
[Concats.xls]Final!B3

should produce the following content:
</title><style type="text/css" media="screen">@impor
"Basic.css";</style><style type="text/css" media="print">@impor
"Print.css";</style><meta http-equiv="Content-type" content="text/html
charset=ISO-8859-1" /><meta name="description" content="Voyage au Brési
- visite virtuelle des villes brésiliennes de : Palmeira dos Índios, Sã
João del-Rei, " /></head><body><a id="Top" /><div id="NavAlpha"><h4>:
Tech</h4><p><a href="Access.html" title="Simplement, Ctrl+lettr
soulignée...">Accessibilité</a><a href="Map.html" title="Mon Michelin
moi">Plan du Site</a></p><h4 class="LinkSplit">:: Morceaux</h4><p><
href="HomepageFr.html" title="Où je m'explique">Home</a><
href="Arrivee" title="Ou départ, selon…">Arrivée au Brésil</a><
href="SJdRUsine.html" title="Beauté dans la nuit">Une nuit
l'usine</a><a href="GlossFr.html" title="Où tou
s'explique">Glossa</p><h4 class="LinkSplit">:: Perso</h4><p><
href="BioFr.html" title="En seulement 25 volumes !...">Bi
(brève)</a><a href="Pix.html" title="Mes beaux yeux">Quelque
photos</a><p class="LastChild">&nbsp;</p></div><div id="NavBeta"><h4>:
Liens</h4><p><a href="http://www.antonino.com.br/" title="Le plus bea
peintre du monde">antonino.com.br</a><
href="http://viuviu.blogspot.com/" title="De l'Estonie à la Terre d
Feu (par moi)">Voyages avec Vika<br />(en anglais)</a><
href="http://viuviu.blogspot.co</p><h4 class="LinkSplit">:
Remerciements</h4><p><a href="Minh.html" title="Celle qui m'a sauvé l
vie">Minh Nguyên-Mordvinoff interprète, traductrice
correctrice...</a><a href="http://HTML Dog.com/" title="Pour apprendr
le html : génial">HTML Dog, par où j'ai commencé</a><
href="http://bluerobot.com</p><p class="LastChild">&nbsp;</p></div><di
class="Content"><h1>Simon Hamilton :: Voyage au Brésil</h1><img src="

When I then concatenate the above int
=CONCATENATE(B1;G1;H1;I1;J1;K1;L1;M1;N1;O1;P1;Q1;R1;S1;T1;U1;V1;W1;X1;Y1;Z1)
it cuts off at:
... <meta name="description" content="Voyage a

and if, for example, I copy cell I1 and paste it into I3 (correctin
the resulting cell value), it truncates at
... <a href="Pix.html" title="Mes beaux yeux">Q
interestingly enough, at 1024 characters.

As you can see, I'm using Excel to generate web pages. Please ignor
the fact I'm using quite the wrong programme for this, it's more
combination of interim solution and learning exercise.

Incidentally, since cutting and pasting into a new file, this glitc
has disappeared, but clones have appeared elsewhere (...title="Où tou
s'explique">Glossa), (...<a href="http://viuviu.blogspot.co). McAfe
assures me I have no viruses.

All help appreciated
 
M

missionarytrader

I think 255 characters is the max number in a cell you can
use with that command. you could put diff parts in diff
cells and CONCATENATE the cells; i.e., concatentate(cell
1, cell 2, cell 3, etc.)
-----Original Message-----

Hello Dave,

Thanks for your reply:

I'm using (a French version of) Windows XP Professional 5.1, with Excel
2003 for students and teachers.

The following formula in cell I1
=[Concats.xls]Final!B3

derived from the formula
=CONCATENATE
Click to expand...
(B5;B6;B7;B8;B9;B10;B11;B12;B13;B14;B15;B16;B17) in
[Concats.xls]Final!B3

should produce the following content:
</title><style type="text/css" media="screen">@import
"Basic.css";</style><style type="text/css" media="print">@import
"Print.css";</style><meta http-equiv="Content-type" content="text/html;
charset=ISO-8859-1" /><meta name="description" content="Voyage au Brésil
- visite virtuelle des villes brésiliennes de : Palmeira dos Índios, São
João del-Rei, " /></head><body><a id="Top" /><div
Click to expand...
id="NavAlpha"> said:
Tech</h4><p><a href="Access.html" title="Simplement, Ctrl+lettre
soulignée...">Accessibilité</a><a href="Map.html" title="Mon Michelin à
moi">Plan du Site</a></p><h4 class="LinkSplit">::
Click to expand...
Morceaux said:
href="HomepageFr.html" title="Où je m'explique">Home</a><a
href="Arrivee" title="Ou départ, selon.">Arrivée au
Click to expand...
Brésil said:
href="SJdRUsine.html" title="Beauté dans la nuit">Une nuit à
l'usine</a><a href="GlossFr.html" title="Où tout
s'explique">Glossa</p><h4 class="LinkSplit">::
Click to expand...
Perso said:
href="BioFr.html" title="En seulement 25 volumes !...">Bio
(brève)</a><a href="Pix.html" title="Mes beaux yeux">Quelques
photos</a><p class="LastChild"> </p></div><div
Click to expand...
id="NavBeta"> said:
Liens</h4><p><a href="http://www.antonino.com.br/" title="Le plus beau
peintre du monde">antonino.com.br</a><a
href="http://viuviu.blogspot.com/" title="De l'Estonie à la Terre de
Feu (par moi)">Voyages avec Vika<br />(en anglais)</a><a
href="http://viuviu.blogspot.co</p><h4 class="LinkSplit">::
Remerciements</h4><p><a href="Minh.html" title="Celle qui m'a sauvé la
vie">Minh Nguyên-Mordvinoff interprète, traductrice,
correctrice...</a><a href="http://HTML Dog.com/" title="Pour apprendre
le html : génial">HTML Dog, par où j'ai commencé</a><a
href="http://bluerobot.com</p><p
Click to expand...
class="LastChild"> said:
class="Content"><h1>Simon Hamilton :: Voyage au
Click to expand...
Brésil said:
When I then concatenate the above into
=CONCATENATE (B1;G1;H1;I1;J1;K1;L1;M1;N1;O1;P1;Q1;R1;S1;T1;U1;V1;W1;X1;Y
1;Z1)
it cuts off at:
... <meta name="description" content="Voyage a

and if, for example, I copy cell I1 and paste it into I3 (correcting
the resulting cell value), it truncates at
... <a href="Pix.html" title="Mes beaux yeux">Q
interestingly enough, at 1024 characters.

As you can see, I'm using Excel to generate web pages. Please ignore
the fact I'm using quite the wrong programme for this, it's more a
combination of interim solution and learning exercise.

Incidentally, since cutting and pasting into a new file, this glitch
has disappeared, but clones have appeared elsewhere (...title="Où tout
s'explique">Glossa), (...<a
Click to expand...
href="http://viuviu.blogspot.co). McAfee
 
D

Dave Peterson

First, I used this in B5:b17:
=REPT("aa ",RANDBETWEEN(100,1000))
and converted to values.

I used the array formula to sum the lengths:
=SUM(LEN(B5:B17))
(ctrl-shift-enter instead of just enter)

And I got 24210 back.

I put your formula in A1 and then =len(a1) in B1 and got 24210 back. They
matched.

I put all your string into B5 and it A1 returned the correct stuff.

I put all your string into B5:b17 and I got 23296 in both cells that checked the
lengths.

I copied and pasted into Notepad (win98's version) and got all the text.

This doesn't quite fit your problem, but if Concats.xls is closed, then you'll
only get 255 characters returned using a formula like:

=[Concats.xls]Final!B3


=====
I still can't duplicate your results.

Well, one more thought. When I pasted your data into excel (just
copy|paste--not into the formula bar), excel converted that mess of HTML junk
<vbg> into what it would look like. Any chance when you're getting the same
problem when you paste into your Txt document?

Are you using NotePad to paste -- or Word or WordPad? (It worked like you
wanted in WordPad with Win98, though--and MSWord 2002, too.)




d'Az said:
Hello Dave,

Thanks for your reply:

I'm using (a French version of) Windows XP Professional 5.1, with Excel
2003 for students and teachers.

The following formula in cell I1
=[Concats.xls]Final!B3

derived from the formula
=CONCATENATE(B5;B6;B7;B8;B9;B10;B11;B12;B13;B14;B15;B16;B17) in
[Concats.xls]Final!B3

should produce the following content:
</title><style type="text/css" media="screen">@import
"Basic.css";</style><style type="text/css" media="print">@import
"Print.css";</style><meta http-equiv="Content-type" content="text/html;
charset=ISO-8859-1" /><meta name="description" content="Voyage au Brésil
- visite virtuelle des villes brésiliennes de : Palmeira dos Índios, São
João del-Rei, " /></head><body><a id="Top" /><div id="NavAlpha"><h4>::
Tech</h4><p><a href="Access.html" title="Simplement, Ctrl+lettre
soulignée...">Accessibilité</a><a href="Map.html" title="Mon Michelin à
moi">Plan du Site</a></p><h4 class="LinkSplit">:: Morceaux</h4><p><a
href="HomepageFr.html" title="Où je m'explique">Home</a><a
href="Arrivee" title="Ou départ, selon…">Arrivée au Brésil</a><a
href="SJdRUsine.html" title="Beauté dans la nuit">Une nuit à
l'usine</a><a href="GlossFr.html" title="Où tout
s'explique">Glossa</p><h4 class="LinkSplit">:: Perso</h4><p><a
href="BioFr.html" title="En seulement 25 volumes !...">Bio
(brève)</a><a href="Pix.html" title="Mes beaux yeux">Quelques
photos</a><p class="LastChild">&nbsp;</p></div><div id="NavBeta"><h4>::
Liens</h4><p><a href="http://www.antonino.com.br/" title="Le plus beau
peintre du monde">antonino.com.br</a><a
href="http://viuviu.blogspot.com/" title="De l'Estonie à la Terre de
Feu (par moi)">Voyages avec Vika<br />(en anglais)</a><a
href="http://viuviu.blogspot.co</p><h4 class="LinkSplit">::
Remerciements</h4><p><a href="Minh.html" title="Celle qui m'a sauvé la
vie">Minh Nguyên-Mordvinoff interprète, traductrice,
correctrice...</a><a href="http://HTML Dog.com/" title="Pour apprendre
le html : génial">HTML Dog, par où j'ai commencé</a><a
href="http://bluerobot.com</p><p class="LastChild">&nbsp;</p></div><div
class="Content"><h1>Simon Hamilton :: Voyage au Brésil</h1><img src="

When I then concatenate the above into
=CONCATENATE(B1;G1;H1;I1;J1;K1;L1;M1;N1;O1;P1;Q1;R1;S1;T1;U1;V1;W1;X1;Y1;Z1)
it cuts off at:
.. <meta name="description" content="Voyage a

and if, for example, I copy cell I1 and paste it into I3 (correcting
the resulting cell value), it truncates at
.. <a href="Pix.html" title="Mes beaux yeux">Q
interestingly enough, at 1024 characters.

As you can see, I'm using Excel to generate web pages. Please ignore
the fact I'm using quite the wrong programme for this, it's more a
combination of interim solution and learning exercise.

Incidentally, since cutting and pasting into a new file, this glitch
has disappeared, but clones have appeared elsewhere (...title="Où tout
s'explique">Glossa), (...<a href="http://viuviu.blogspot.co). McAfee
assures me I have no viruses.

All help appreciated!
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CSS Problems 9
Stop width and height attributes attaching to img tag? 8
Problem seeing some characters when sending email to Outlook client 60
Endspan Checksum increasing every time published 5
Error setting up Attribute Mapping Template 1
How do I define the style of the output from the build in FrontPage search engine? 5
Aligning trouble 4
problem with css and picture 2

Top