Hi All - I hope someone can help me with this!
I am using the following formula: =CONCATENATE($Page.$B$6;$'Data'.C9;$Page.$B$7)
In the 'Data' range, i have some values with leading zeros. When using the concatenate formula, these leading zeros do not follow through. For example, I get the following:
http://www.site.com/cat/prod/part=70/501
when I want this (note the two leading zeros in 0070):
http://www.site.com/cat/prod/part=0070/501
How can I make this work?
I am using the following formula: =CONCATENATE($Page.$B$6;$'Data'.C9;$Page.$B$7)
In the 'Data' range, i have some values with leading zeros. When using the concatenate formula, these leading zeros do not follow through. For example, I get the following:
http://www.site.com/cat/prod/part=70/501
when I want this (note the two leading zeros in 0070):
http://www.site.com/cat/prod/part=0070/501
How can I make this work?