+ Reply to Thread
Results 1 to 3 of 3

can i write a macro to truncate alpha-numeric data?

  1. #1
    T-Dot
    Guest

    can i write a macro to truncate alpha-numeric data?

    I have imported a bunch of data into excel, however, the data I have has a
    bunch of extra characters at the end that I don't need. Can I write a Macro
    to delete a set number of characters off of each cell that I run the macro on?

  2. #2
    Forum Contributor
    Join Date
    12-12-2005
    Posts
    667
    This is the key code:
    a = Replace(ActiveCell.Value, "s", "")
    the rest is up to you!
    Best regards,

    Ray

  3. #3
    paul
    Guest

    RE: can i write a macro to truncate alpha-numeric data?

    you dont necessarily need a macro .Post a sample of what the dates look like
    now what you want them to look like
    --
    paul
    paul.shepherd@nospamparadise.net.nz
    remove nospam for email addy!



    "T-Dot" wrote:

    > I have imported a bunch of data into excel, however, the data I have has a
    > bunch of extra characters at the end that I don't need. Can I write a Macro
    > to delete a set number of characters off of each cell that I run the macro on?


+ Reply to Thread

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