automated cut and paste using regex

E

excel_newbie

Have a question... I know there must be a way to automate this process
and wondering if someone could help me out...
column A has motorcycle part numbers i.e. HD101ST-500CC-004MK,
K113-600R-17-00LK4, etc.
these part numbers always end with 5 alphanumeric characters. I want
to "copy" the last 5 alphanumeric characters and paste them into
column B because this will become its truncated id number. There's
about a 100 or so rows in each spreadsheet so I would like to
automated this process by using some kind of function, macro, etc.
that will just loop through column A extracting the last 5 of each
part number, then paste those 5 alphanumerics into the corresponding B
column. I know there must be a way but not sure how to get started or
accomplish this in excel 2000. Thanks for any ideas or assistance in
advance.

+---------------------------------------+-------------------------+
| Column A | Column B |
+---------------------------------------+-------------------------+
| HD101ST-500CC-004MK | 004MK |
+---------------------------------------+-------------------------+
| K113-600R-17-00LK4 | 00LK4 |
+---------------------------------------+-------------------------+
 
J

John

HI
You could copy this formula down column B
=RIGHT(A1,5). change A1 to your needs.
HTH
John
 

Ask a Question

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. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the proper style field and the numbered paragraph value within the style 0
Match issue 3
Excel VBA macro, search - accumulate - delete original 0
Combining two separate lists and creating new values 5
VLOOKUP and IF together 3
Help with lots of formulas 3
Copy and paste from one tab to another with certain rules using VBA 3
Using COUNTIF with criteria in an adjacent column? 5

Top