Welcome Guest
Log In | Register )
You last visited December 4, 2016, 11:14 am
All times shown are
Eastern Time (GMT-5:00)

Microsoft excell

Topic closed. 1 reply. Last post 9 years ago by vick.

Page 1 of 1
PrintE-mailLink
Avatar
Mount Morris
United States
Member #46750
September 27, 2006
139 Posts
Offline
Posted: January 13, 2008, 1:22 pm - IP Logged

Need some formulas for a cell

I got a 4 digit --  1596      now I want to change say the 2 digit which is the 5 to a 9 I have bunch of picks so thats why I need a formula to do this.

next formula 

And say your plays have a 2 in them and you want to change all the 2 to a 5 

    Avatar

    Canada
    Member #2859
    November 23, 2003
    463 Posts
    Offline
    Posted: January 13, 2008, 2:53 pm - IP Logged

    Need some formulas for a cell

    I got a 4 digit --  1596      now I want to change say the 2 digit which is the 5 to a 9 I have bunch of picks so thats why I need a formula to do this.

    next formula 

    And say your plays have a 2 in them and you want to change all the 2 to a 5 

    =SUBSTITUTE(A1,5,9)

     

    =SUBSTITUTE(A1,2,5) 

     

    in this case the original number was in cell

    A1