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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. craigwojo

    Simple Simple Simple

    craigwojo, Aug 29, 2004, in forum: Microsoft Excel New Users
    Replies:
    3
    Views:
    366
  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:
    167
    JE McGimpsey
    Jan 24, 2005
  3. Guest

    Simple Hyperlink Macro

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

    Simple macro please

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

    Simple Macro

    Guest, Jul 27, 2006, in forum: Microsoft Excel New Users
    Replies:
    3
    Views:
    263
    Don Guillett
    Jul 27, 2006
Loading...

Share This Page