PC Review


Reply
Thread Tools Rate Thread

Need Simple Macro

 
 
jreinert
Guest
Posts: n/a
 
      15th Jun 2006

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...o&userid=35448
View this thread: http://www.excelforum.com/showthread...hreadid=552248

 
Reply With Quote
 
 
 
 
=?Utf-8?B?Q0xS?=
Guest
Posts: n/a
 
      15th Jun 2006
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...o&userid=35448
> View this thread: http://www.excelforum.com/showthread...hreadid=552248
>
>

 
Reply With Quote
 
 
 
 
Bob Phillips
Guest
Posts: n/a
 
      15th Jun 2006
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" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> 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...o&userid=35448
> View this thread: http://www.excelforum.com/showthread...hreadid=552248
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Simple questions for simple 2 PC file sharing network. Simple? raylopez99 Microsoft Windows 2000 Networking 3 11th Feb 2007 02:31 PM
Simple Simple Simple craigwojo Microsoft Excel New Users 3 29th Aug 2004 05:32 AM
Simple Macro is not so simple Aardvark Microsoft Excel Discussion 2 9th May 2004 10:58 PM
need help on simple thread (simple I hope!) - Dan - Microsoft VB .NET 2 15th Apr 2004 02:05 PM
I need a simple keyboard macro program FireBrick Windows XP General 1 2nd Feb 2004 03:04 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:58 PM.