Results 1 to 9 of 9

Separate Alpha and numeric characters

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-21-2009
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    112

    Separate Alpha and numeric characters

    Dear all,

    I need a macro to delete only the alphabets which are entered along with numbers. Ex: 300ML. BY running a macro i need to delete only the "ML" and the number 300 should remain the same.

    Range is For Rows: Entire rows
    For columns: F TO P

    The cell values betwwen these ranges contains alphanumeric such as 20KG,300ML,200M ...etc

    Hence i need a macro to delete the alpha charecters for the particular range.

    Can anybody help me in this regard.


    Thanks in Advance.

    Alex
    Last edited by sivdin; 05-06-2009 at 06:26 AM.

Thread Information

Users Browsing this Thread

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

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