Function for consolidating numbers

  • Thread starter Thread starter dabliss74
  • Start date Start date
D

dabliss74

ok, heres the deal...I seem to have forgotten the function fo
consolidating the following scenario..... 719-555-1212 t
7195551212.... I cant remember the actual function...I think th
string includes; left(1,3) & mid(5,3) & mid(9,1,4) (i think)...PLEAS
HELP ME
 
You could use left/mid/right, but if all you have are dashes, this'll work, too:

=substitute(a1,"-","")

Or how about just selecting your range, edit|replace dash with nothing.
 
ok, say I have a mix of delimiters; would I use the susbstitue functio
the same way ie 719-661-5555 and 719*661*5556 to 7196615555 an
7196615556 how would I go about accomplishing the same the same resul
as the previous (susbstitute function) post
 
Back
Top