+ Reply to Thread
Results 1 to 3 of 3

Alter Script To Remove All None Numerical Characters, Except For Decimal Points

  1. #1
    Forum Contributor
    Join Date
    10-29-2019
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    156

    Alter Script To Remove All None Numerical Characters, Except For Decimal Points

    Hi, I've got a script to remove all none numerical characters, but it also removes decimal points.

    How do I modify it to keep the decimal points & comma's ...

    Thanks.,

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Genus Max; 09-21-2020 at 12:05 PM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Alter Script To Remove All None Numerical Characters, Except For Decimal Points

    Include ASC 46 in your case argument

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    10-29-2019
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    156

    Re: Alter Script To Remove All None Numerical Characters, Except For Decimal Points

    Works great, thanks!

+ 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. Remove Text characters, leaving numerical characters
    By aschwalge in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-01-2016, 06:42 PM
  2. [SOLVED] VBA, remove all characters within a string, except numerical characters and full stops
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-25-2015, 09:24 PM
  3. Need simple script to remove special characters in column A
    By gspreeman in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-14-2014, 04:50 PM
  4. [SOLVED] Round off numbers and remove decimal points
    By bmbalamurali in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-08-2014, 01:14 PM
  5. [SOLVED] i want re alter my numbers with special characters
    By vengatvj in forum Excel General
    Replies: 20
    Last Post: 09-30-2013, 06:51 PM
  6. Remove Decimal Points
    By ringrim in forum Excel General
    Replies: 3
    Last Post: 08-20-2008, 08:37 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1