Results 1 to 15 of 15

Deleting last two characters in a cell

Threaded View

  1. #1
    Registered User
    Join Date
    03-02-2010
    Location
    Switzerland
    MS-Off Ver
    Excel 2003
    Posts
    6

    Unhappy Deleting last two characters in a cell

    Everyone,

    I would really be grateful if someone could help me with the following:

    In a column I have several rows (on average 100 rows) in which values like the following are defined: EP10000001A1. Thus, it looks something like the following

    EP10000001A1
    EP10000002A1
    EP10000003A1
    EP10000004A1

    I would like to delete the last two characters in ever cell for every row. Hence, taking the above example all "A1" should be deleted so that it should looks like this:

    EP10000001
    EP10000002
    EP10000003
    EP10000004

    As I said, on average I have a 100 rows in a column (sometimes up to 300 rows). Hence, I would really like to avoid doing this manually. How can I achieve this? Is there a standard Macro for this type of operation? (I must admit that I am new to VBA/creation of Macros).

    Thank you in advance.

    Best regards,
    tony
    Last edited by patentprio; 03-04-2010 at 06:11 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