I have a worksheet with addresses of the clients, so each row represent
one client (Name, Title;Street+no, ZIP, city ...)
I would need to put on the first column a special hyperlink, which will
be composed from the values of next columns.
So the hyperlink would look like
http://www.abc.abc?Parameters=Excel;John D**k;0;Lombard street
But the hyperlink does not work, when in one or more of the cells is a
value containing space - in this example the name and street. I've
tried to replace the spaces with %20, but still the same. Simply Excel
will not open the browser, nor display an error message in those
However, if I remove the space, it works.
This problem occurs only in Excel 2003, in XP it works..