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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. patrok

    Excel VBA: Can't get the "Replace" method to work...

    Just found my mistake! ENname="Brussels " and not "Brussels"... The difference is subtle, but obviously vital... Thanks! Patrick.
  2. patrok

    Excel VBA: Can't get the "Replace" method to work...

    Hi Geoff, Yes, I did do the debug using F8 : as the "translation" sheet is being parsed, you can see the values of ENname and FRname being updated just as they should. For instance: - WORKS CORRECTLY: ENname="Brussels" FRname="Bruxelles" Worksheets("Geo").Columns("I:L").Replace _...
  3. patrok

    Excel VBA: Can't get the "Replace" method to work...

    Hi there, I have a excel spreadsheet with 2 sheets: - "Geo" sheet: containing name of places (columns I to L in French and columns M to P in English) - "Translation" sheet: contain the translation between French and English (Column A=name in English; column B=name in French) My goal is to use...
  4. patrok

    MS Access: Extract Email address from cell containing Free Text

    CautionMP, I can't thank you enough!!! :-) It's more than I could ask! Cheers, Patrick.
  5. patrok

    MS Access: Extract Email address from cell containing Free Text

    Hi guys! Hope you can help me with this one: - I have a huge MS Access table. - One of the columns is free text; let's call it "FreeTextColumn". - Each cell in FreeTextcolumn is free text, and contains either 0 or 1 email address. - If there is 1 email address, I need to extract it from the...

Part and Inventory Search

Back
Top