Results 1 to 4 of 4

Thread: VBA: keep only one searched string.

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 09-27-2022, 02:29 AM #1
    santa1234
    santa1234 is offline
    Junior Member
    Join Date
    Apr 2022
    Posts
    10
    Rep Power
    0

    VBA: keep only one searched string.

    VBA: keep only one searched string.
    The list of search stings is given in sheet 2.
    In sheet1, with VBA check if a given string is found more than once in a paragraph/line. If found more than once then keep only one.
    I want to do this both in an excel sheet with multiple column data in multiple rows as well as in a CSV or text file.
    Attached Files Attached Files
    Last edited by santa1234; 09-27-2022 at 04:22 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. "What’s in a String"- VBA break down Loop through character contents of a string
    By DocAElstein in forum Excel and VBA Tips and Tricks
    Replies: 26
    Last Post: 07-09-2023, 04:57 PM
  2. in VBA if the given string is found then delete everything between two newlines where the string appears.
    By santa1234 in forum Excel Help
    Replies: 4
    Last Post: 10-02-2022, 09:18 PM
  3. PQ - Extract initial letters string from longer string with different length
    By sandy666 in forum ETL PQ Tips and Tricks
    Replies: 0
    Last Post: 07-08-2020, 04:29 PM
  4. Looping Through String Using Excel VBA!
    By Jdean in forum Excel Help
    Replies: 15
    Last Post: 09-12-2014, 09:24 AM
  5. VBA Using MID Function To Replace Portion Of A String
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 1
    Last Post: 05-30-2013, 08:22 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules