Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: drfads07
  • Order by date
  1. drfads07

    Excel

    Sweet, thanks for all your help guys. Now: I am trying to invoke this script whenever someone pastes something: For instance: I place 123-987-6541 in Cell A1; I want it to automatically chnage to "1239876541" with the dashes gone. All automatically without having to manually run the macro- i...
  2. drfads07

    Excel

    Thanks Pete. I will try that: Regards
  3. drfads07

    Excel

    PST09 That addition seems to be inappropriate. I think I will need to refine. Thanks for the posting.
  4. drfads07

    Excel

    Electric Pete Thank you for that post; Can I change "mycell" to a range; For instance an entire column (m1:M10000). I am having trouble changing to this. Your help will be appreciated. Regards Swertel' I use a lot excel and is the only software available to me_ Hence the persistence. Thanks...
  5. drfads07

    Excel

    I have a VB script as follows: How can I write loop for this:- Sub format() Dim X As Variant X = range("M1") X = Replace(X, "-", "", 1) 'The next line puts the cleaned up data back in J1 range("M1") = X End Sub Thank you all for your previous answers.
  6. drfads07

    Excel

    Is there a way where you could display both the formula and its out put in the same cell. For instance: I am using a "substitution" formula which removes dashes from numbers- I want the output of that formula to be displayed in the same cell. OR: If there is a way excel can automatically...

Part and Inventory Search

Back
Top