Cell Formatting Removing Dashes
 

I am working with Excel, trying to remove dashes from Text "000-000-000-000"
but still keep zeros. The cell MUST keep all 12 digits including zeros for
it to work for me. The data is imported from a report program as delimited
text, and then I have to import the data to Access for a different program.
HELP!!!!!

Cell Formatting Removing Dashes
 

Try
=SUBSTITUTE(A1,"-","")
The cell must be formatted as text to retain the leading zeros,
Regards,
Alan.
"GIS Tech II" wrote in message
...
I am working with Excel, trying to remove dashes from Text
"000-000-000-000"
but still keep zeros. The cell MUST keep all 12 digits including zeros
for
it to work for me. The data is imported from a report program as
delimited
text, and then I have to import the data to Access for a different
program.
HELP!!!!!

Cell Formatting Removing Dashes
 

Alan,

Thanks a million, I'm not sure why I didn't think of creating a new
column.........

"Alan" wrote:

Try
=SUBSTITUTE(A1,"-","")
The cell must be formatted as text to retain the leading zeros,
Regards,
Alan.
"GIS Tech II" wrote in message
...
I am working with Excel, trying to remove dashes from Text
"000-000-000-000"
but still keep zeros. The cell MUST keep all 12 digits including zeros
for
it to work for me. The data is imported from a report program as
delimited
text, and then I have to import the data to Access for a different
program.
HELP!!!!!