Edit a group of cells with a macro

[Michael CPA]

I have imported data from another program which combines numeric and alpha characters into a single cell. I need to split the numeric data into one column and the alpha characters into an adjacent column. I copied the imported column into the adjacent column, then went to first column and created a macro which deletes the first 7 characters (the numeric values). When I run the macro on other cells it takes the information from the very first cell and keeps repeating it. What am I doing wrong?

 

[AlfD]

Hi!

Can you post a few examples of the data you want to separate?

Al

 

[icestationzbra]

there is a similar thread in currency. check that out, it might sui
your requirements with a little tweaking, as you just need to split an
not to delete. ask gord dibben, if you have questions.

this is the link and if you are not able to open this, the thread'
title is "String Manipulation" posted originally by "Jack Schitt".

http://www.excelforum.com/showthread.php?threadid=235997&highlight=string+manipulatio

 

[Gord Dibben]

Michael

Use Data>Text to Columns with a delimiter of "-"(no quotes) to split these
into two columns.

Gord Dibben Excel MVP