Currently Being ModeratedNov 16, 2012 2:55 PM (in response to Mike2Simpson)
Currently Being ModeratedNov 16, 2012 5:02 PM (in response to Wayne Contello)
Thanks wayne for the clarification. That's basically what I had to do. Though as you can imagine if there are, not only "-"'s and parentheses, but periods, pluses, stars, pound signs and ampersands, the function could get a little messy to the user.
The only thing I could think of are that was to reference each of the SUBSTITUTED character out to a different column so that if wierd symbols arise they can just be enter in and referenced in the the long and messy SUBSTITUTE function.