Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting concatenation formula to text
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting concatenation formula to text
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 ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting concatenation formula to text
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting calculation expressed as text into a formula | Excel Discussion (Misc queries) | |||
converting results from formula to text in a new column | New Users to Excel | |||
Converting text string back into a formula | Excel Discussion (Misc queries) | |||
converting constant/text to formula and evaluate it | Excel Programming | |||
Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) |