Results 1 to 10 of 11

Thread: How To Split A Text Based On Two Special Characters

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #10
    Senior Member
    Join Date
    Jun 2012
    Posts
    337
    Rep Power
    14
    I came up with:

    Code:
    Function F_snb(c00)
        F_snb = Split(c00, ">")(0) & ">" & Replace(Filter(Split(Replace(Replace(c00, ">", "/"), ";", "~/"), "/"), "~")(0), "~", "")
    End Function
    Last edited by snb; 09-10-2014 at 12:16 PM.

Similar Threads

  1. Replies: 3
    Last Post: 02-24-2014, 05:48 AM
  2. Remove Special Characters From Text Or Remove Numbers From Text
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 5
    Last Post: 05-31-2013, 04:43 PM
  3. Replies: 5
    Last Post: 05-28-2013, 03:00 AM
  4. Replies: 4
    Last Post: 05-01-2013, 09:49 PM
  5. Remove Special Characters :
    By Rajan_Verma in forum Rajan Verma's Corner
    Replies: 3
    Last Post: 03-06-2012, 09:41 PM

Posting Permissions

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