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. 09-08-2014, 12:31 AM #1
    Charles
    Charles is offline
    Member Charles's Avatar
    Join Date
    Aug 2012
    Posts
    63
    Rep Power
    13

    How To Split A Text Based On Two Special Characters

    Hi,

    I can usually solve my problems. But, in this case I may be having a "CRAFT" moment.
    What I'm trying to do is split a string form this

    Code:
    c.2339A>A/C; p.N780T
    to

    Code:
    c.2339A>C
    I know its something simple but...

    Thank for any help.

    I'm looking for VBA.

    HI. I also have this posted on:

    http://www.mrexcel.com/forum/excel-q...ml#post3930583
    Last edited by Charles; 09-08-2014 at 01:10 AM. Reason: Posted else where
    If you like the answer, please click " * " below Member name to say thanks.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Split And Separate Data In To Columns Based On Delimiter Using Text To Column
    By msiyab in forum Excel Help
    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. Distribute Debt Across Time Period Split A Number Based On Another Split Ratio
    By mahmoud-lee in forum Excel Help
    Replies: 5
    Last Post: 05-28-2013, 03:00 AM
  4. Split Data in Table To Multiple Rows Based On Delimited Text In Columns
    By nick5_86 in forum Excel Help
    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

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