Need Simple Macro

Discussion in 'Microsoft Excel New Users' started by jreinert, Jun 15, 2006.

  1. jreinert

    jreinert Guest

    jreinert, Jun 15, 2006
    #1
    1. Advertisements

  2. jreinert

    Guest Guest

    No macro needed......In B1 put this formula and copy down..........

    =RIGHT(a1,7)

    Vaya con Dios,
    Chuck, CABGx3



    "jreinert" wrote:

    >
    > I need a macro to examine column A for alpha-numeric value, leave the
    > data in column A as is, and copy the numeric data into column B.
    >
    > The data is in only 1 of 2 formats:
    >
    >
    > xxxxx1234567
    > xxx1234567
    >
    >
    > Thanks in advance.
    >
    >
    > --Joe
    >
    >
    > --
    > jreinert
    > ------------------------------------------------------------------------
    > jreinert's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35448
    > View this thread: http://www.excelforum.com/showthread.php?threadid=552248
    >
    >
     
    Guest, Jun 15, 2006
    #2
    1. Advertisements

  3. jreinert

    Bob Phillips Guest

    In C1 add

    =MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),99)

    In B1,

    =SUBSTITUTE(A1,C1,"")

    --

    HTH

    Bob Phillips

    (replace xxxx in the email address with gmail if mailing direct)

    "jreinert" <> wrote in
    message news:...
    >
    > I need a macro to examine column A for alpha-numeric value, leave the
    > data in column A as is, and copy the numeric data into column B.
    >
    > The data is in only 1 of 2 formats:
    >
    >
    > xxxxx1234567
    > xxx1234567
    >
    >
    > Thanks in advance.
    >
    >
    > --Joe
    >
    >
    > --
    > jreinert
    > ------------------------------------------------------------------------
    > jreinert's Profile:

    http://www.excelforum.com/member.php?action=getinfo&userid=35448
    > View this thread: http://www.excelforum.com/showthread.php?threadid=552248
    >
     
    Bob Phillips, Jun 15, 2006
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. craigwojo

    Simple Simple Simple

    craigwojo, Aug 29, 2004, in forum: Microsoft Excel New Users
    Replies:
    3
    Views:
    579
  2. Rahim Kassam

    New Excel user needs help with simple Macro...

    Rahim Kassam, Jan 24, 2005, in forum: Microsoft Excel New Users
    Replies:
    1
    Views:
    228
    JE McGimpsey
    Jan 24, 2005
  3. Guest

    Simple Hyperlink Macro

    Guest, Apr 10, 2005, in forum: Microsoft Excel New Users
    Replies:
    3
    Views:
    275
    Guest
    Apr 10, 2005
  4. Guest

    Simple macro please

    Guest, Jul 19, 2005, in forum: Microsoft Excel New Users
    Replies:
    1
    Views:
    212
    Bob Phillips
    Jul 19, 2005
  5. Guest

    Simple Macro

    Guest, Jul 27, 2006, in forum: Microsoft Excel New Users
    Replies:
    3
    Views:
    327
    Don Guillett
    Jul 27, 2006
  6. R. H. Rosenberg

    How to write a simple copy-paste macro?

    R. H. Rosenberg, Nov 22, 2006, in forum: Microsoft Excel New Users
    Replies:
    4
    Views:
    2,251
    R. H. Rosenberg
    Nov 25, 2006
  7. Guest

    I really need help. Need a formula. Need it yesterday.

    Guest, Mar 11, 2007, in forum: Microsoft Excel New Users
    Replies:
    1
    Views:
    662
    Guest
    Mar 12, 2007
  8. Don Guillett

    Re: Assistnace with simple Macro

    Don Guillett, Apr 10, 2007, in forum: Microsoft Excel New Users
    Replies:
    3
    Views:
    196
    Guest
    Apr 11, 2007
Loading...