have you tired using Find and Replace (Ctrl + H)
--
HTH...

Jim Thomlinson


"Andre F" wrote:

I am trying to remove the hyphen from between social security numbers;I'm
able to do so using the 'text to column' function, but I am having a problem
with those numbers that are preceded by 0's eg : 001-23-0077 the function is
dropping the zero's and returning 1-23-77....