Converting concatenation formula to text

Hi all,

I am concatenating two numbers to create a sort key in a list column but
find that I cannot sort on the concatenated field. I am now trying to
convert the concatenation formula to text which will allow me to sort on it
(similar to copy and paste values).

Apart from adding code to do the copy and paste values thing, can anyone
offer a better solution?

Thanks for any help.

FD

what's an example of the concatenated value?

--


Gary


"FrigidDigit" <lawrencekritzinger@hotmail.com> wrote in message
news:dj7h6n$k0$1@ctb-nnrp2.saix.net...
> Hi all,
>
> I am concatenating two numbers to create a sort key in a list column but
> find that I cannot sort on the concatenated field. I am now trying to
> convert the concatenation formula to text which will allow me to sort on
> it (similar to copy and paste values).
>
> Apart from adding code to do the copy and paste values thing, can anyone
> offer a better solution?
>
> Thanks for any help.
>
> FD
>

Hi Gary,

Thanks for the response!

I apologize, my code was wrong, can sort on concatenated string.

I apologize for wasting your time!

FD

"Gary Keramidas" <GKeramidasATmsn.com> wrote in message
news:eYq9JlU1FHA.732@TK2MSFTNGP10.phx.gbl...
> what's an example of the concatenated value?
>
> --
>
>
> Gary
>
>
> "FrigidDigit" <lawrencekritzinger@hotmail.com> wrote in message
> news:dj7h6n$k0$1@ctb-nnrp2.saix.net...
>> Hi all,
>>
>> I am concatenating two numbers to create a sort key in a list column but
>> find that I cannot sort on the concatenated field. I am now trying to
>> convert the concatenation formula to text which will allow me to sort on
>> it (similar to copy and paste values).
>>
>> Apart from adding code to do the copy and paste values thing, can anyone
>> offer a better solution?
>>
>> Thanks for any help.
>>
>> FD
>>
>
>

What happens? Any error message? I CAN sort on concatenated numbers! Give
sample data!
Stefi


„FrigidDigit” ezt �*rta:

> Hi all,
>
> I am concatenating two numbers to create a sort key in a list column but
> find that I cannot sort on the concatenated field. I am now trying to
> convert the concatenation formula to text which will allow me to sort on it
> (similar to copy and paste values).
>
> Apart from adding code to do the copy and paste values thing, can anyone
> offer a better solution?
>
> Thanks for any help.
>
> FD
>
>
>

Hi Stefi

Thanks for the response!

I apologize, my code was wrong, can sort on concatenated string.

I apologize for wasting your time!

FD
"Stefi" <Stefi@discussions.microsoft.com> wrote in message
news:15C0E14B-E9EC-4944-A44C-E77DE575F953@microsoft.com...
> What happens? Any error message? I CAN sort on concatenated numbers! Give
> sample data!
> Stefi
>
>
> "FrigidDigit" ezt �rta:
>
>> Hi all,
>>
>> I am concatenating two numbers to create a sort key in a list column but
>> find that I cannot sort on the concatenated field. I am now trying to
>> convert the concatenation formula to text which will allow me to sort on
>> it
>> (similar to copy and paste values).
>>
>> Apart from adding code to do the copy and paste values thing, can anyone
>> offer a better solution?
>>
>> Thanks for any help.
>>
>> FD
>>
>>
>>