 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / April 2007how to selectively delete digits in a number?
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? =SUBSTITUTE(SUBSTITUTE(MID(A2,3,99),"-","",1),"-","",1)  SignatureHTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > I have a long list of numbers that I need to change. > the original number is: [quoted text clipped - 7 lines] > > can anyone help me? I tried this one, but it didnt work. this may be because I use excel 2003. I have had problems with this before. sometimes it helps to substitute the (,) with (;). although it didnt this time. I tried the other response, which worked, so then I forgot about this one. in other words, it might work, I just dont know how! > =SUBSTITUTE(SUBSTITUTE(MID(A2,3,99),"-","",1),"-","",1) > [quoted text clipped - 9 lines] > > > > can anyone help me? FYI: Bob's formula worked OK for me with Excel 2003. > I tried this one, but it didnt work. this may be because I use excel 2003. I > have had problems with this before. sometimes it helps to substitute the (,) [quoted text clipped - 15 lines] > > > > > > can anyone help me? I use 2003 too. Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) >I tried this one, but it didnt work. this may be because I use excel 2003. >I [quoted text clipped - 18 lines] >> > >> > can anyone help me? =MID(A2,3,2)&MID(A2,6,2)&RIGHT(A2,7) > I have a long list of numbers that I need to change. > the original number is: [quoted text clipped - 7 lines] > > can anyone help me? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.