Welcome Guest
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
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

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

 Page 1 of 1