how to selectively delete digits in a number?
=SUBSTITUTE(SUBSTITUTE(MID(A2,3,99),"-","",1),"-","",1)
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"spreadsheet monkey" wrote in
message ...
I have a long list of numbers that I need to change.
the original number is:
1961-04-10-2691
I need it to be:
610410-2691
in other words, I need the first two numbers to go away and the first two
minus signs (-) to go away.
can anyone help me?
|