+ Reply to Thread
Results 1 to 6 of 6

How can I remove a forward slash from Text????

  1. #1
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    How can I remove a forward slash from Text????

    Morning All,

    I have adapted some code to take the contents of comboBox10 (9th) Character and place in contents
    of TextBox5.

    So, TextBox5 contains the following: "4/100"

    The code below works fine, but I'd like to remove theforward slash "/" so it reads: "4100".

    Any ideas?




    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: How can I remove a forward slash from Text????

    Mouse bounce
    Last edited by cytop; 10-24-2016 at 04:17 AM.

  3. #3
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: How can I remove a forward slash from Text????

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    Re: How can I remove a forward slash from Text????

    I got this ?
    Attached Images Attached Images

  5. #5
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: How can I remove a forward slash from Text????

    Change the full stop before vbNullString to a comma.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  6. #6
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    Re: How can I remove a forward slash from Text????

    Thanks you lads, worked great!!!!!!!!!!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to remove the slash before text in substitute
    By silambarasan.J in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-28-2016, 02:51 PM
  2. [SOLVED] Remove the characters after last Forward slash
    By Shareez Saleem in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-14-2015, 01:34 AM
  3. [SOLVED] Search Function for String with Forward Slash
    By T86157 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-30-2015, 01:10 PM
  4. How do you remove all text before the last forward slash?
    By lukesmith7 in forum Excel General
    Replies: 7
    Last Post: 05-22-2014, 07:59 AM
  5. How do you remove text before the last forward slash?
    By lukesmith7 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-22-2014, 07:31 AM
  6. Automatic insert of forward slash (/)
    By Shivas Regal in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-08-2010, 04:27 PM
  7. Forward Slash Problem
    By mortikiv in forum Excel General
    Replies: 3
    Last Post: 11-06-2007, 01:59 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1