View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default Converting concatenation formula to text

what's an example of the concatenated value?

--


Gary


"FrigidDigit" wrote in message
...
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